Count and select

[Anchor_Appadmin]

I have created a slice for last 7 days report and names as " 7day reports". From these slice i want to create report through email.
I want the count of the column.
So i have used COUNT(SELECT in word template

But this work in single column only. But i want multiple column. Means i want to know the count of two coloums based criteria

[Steve]

Like COUNT(SELECT(...)) + COUNT(SELECT(...)) or COUNT(SELECT(...) + SELECT(...))?

[Anchor_Appadmin]

This means adding the counts Or is this work with multiple filter count. Like i want count like “type of work completed” , “type of work pending”

If type and status is the column what is the formula. The type have more categories

[Steve]

I’m really not exactly sure what you want. Could you explain further?

[Steve]

There’s no good way to do that automatically. You’ll have to create one virtual column for each specific count you want.

[Steve]

I don’t understand what you mean.