Average Partial Sum Column

[#1]

I have a pivot table by REseller (rows) then columns for quarter sub divided by division

I set a partial sum for the quarters but I want this to average the 4 qtrs within each division, not sum. How do I do this?

[johnw]

I think by changing your expression to something like this:

if(dimensionality()=2,avg(aggr(sum(Quantity),Reseller,Division,Quarter)),sum(Quantity)))

But it's really hard to get the specifics right without an example to play with.