Need to get the sum of an expression in a Pivot

[Anonymous]

Hi All

I need some help, been looking for a solution on the forums without any success.

I would like to get the sum of the values in row: Test displayed in each column.

So for Row

Test(A), I am expecting 1 in both "201901" and "201902"

Test(B), I am expecting 2 in both "201901" and "201902"

Test(C), I am expecting 2 in both "201901" and "201902"

Test(D), I am expecting 1 in both "201901" and "201902"

My Expression Used for Test is:

= sum(Aggr(if(sum(Actual) = 0, 1, 0), [BP Practice Code], [BP Adviser Code], [BP Provider Code], [BP Sub Group], [BP Period]))

I have also tried aggregating the expression by it's Label(ie. Test) but QV states: Bad Field Names

Any assistance would be appreciated.

Regards