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".