Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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
That did it. I was pretty close with something like that, but i didnt add the 2nd dimension in the AGGR() 😕
Thank you!
You are welcome. I am glad I was able to help.