Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If you've got Customer and OrderNo as dimensions, try
=rangesum(above(sum(Sales),0,RowNo()))
If you've got Customer and OrderNo as dimensions, try
=rangesum(above(sum(Sales),0,RowNo()))
Swuehl, that doesn't appear to work! That is what I had tried before...
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.