Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
As you can see from my attachment, my partial sum total is incorrect by about 200 on a pivot
Anyone any ideas why this happens.
My dimensions are
Country
2 Cyclic groups
Calendar cyclic group consisting of Year, YearMonth, YearWeek
Expression
count (distinct (case_no)
Any help appreciated
Use Sum(Aggr())... like this
Sum(Aggr(Count(DISTINCT case_no), Country, [$(=GetCurrentField(Group1)], [$(=GetCurrentField(Group2)], [$(=GetCurrentField(Group3)]))
Use Sum(Aggr())... like this
Sum(Aggr(Count(DISTINCT case_no), Country, [$(=GetCurrentField(Group1)], [$(=GetCurrentField(Group2)], [$(=GetCurrentField(Group3)]))
Hi
I think is because the "DISTINCT" clause.
Inside any row of your table you are counting this distinct but in the total row there are case_no that are in more than a row and is counted only once.
Regards