Accumulation - Pivot Chart

[#1]

Hi

I need to have a column that accumulates sales by Customer and not just a rolling full accumulation! Please see the picture attached so you can see what I need to achieve... Any help would be greatly appreciated

[swuehl · Accepted solution]

If you've got Customer and OrderNo as dimensions, try

=rangesum(above(sum(Sales),0,RowNo()))

[#3]

Swuehl, that doesn't appear to work! That is what I had tried before...

[swuehl]

If you have two dimensions in a pivot table, both dimensions not pivoted to the top, or a straight table with dimension values sorted appropriately, I think it should work. See attached.