Partial Sum Wrong in a 2 Dimensional Pivot Table

[Anonymous]

Hi Everyone,

I've taken many tries at getting this pivot table to display the total column correctly with partial sum checked on the FiscalMonth field. I'm sure it involves an AGGR(). I even tried a sum(aggr(count())). Can anybody please help me to get the rows to total correctly on the right of the chart? I've attached a sample QVW.

The two expressions that are wrong appear to be just "Units" and "Total Claims".

Thanks a lot!

[sinanozdemir · Accepted solution]

Hi,

What I tried was the below expression for the count() functions:

I only checked two rows so let me know if it is working for you.

Thanks

[Anonymous]

That did it. I was pretty close with something like that, but i didnt add the 2nd dimension in the AGGR() 😕

Thank you!

[sinanozdemir]

You are welcome. I am glad I was able to help.