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