Partial sum incorrect

[bobbydave]

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

[sunny_talwar · Accepted solution]

Use Sum(Aggr())... like this

Sum(Aggr(Count(DISTINCT case_no), Country, [$(=GetCurrentField(Group1)], [$(=GetCurrentField(Group2)], [$(=GetCurrentField(Group3)]))

[jmvilaplanap]

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