3 Replies Latest reply: Dec 10, 2015 3:40 PM by Sinan Ozdemir RSS

    Partial Sum Wrong in a 2 Dimensional Pivot Table

    Ron Payne

      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!