Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Accumulation - Pivot Chart

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

Accumulation.png

1 Solution

Accepted Solutions
MVP
MVP

Re: Accumulation - Pivot Chart

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

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

3 Replies
MVP
MVP

Re: Accumulation - Pivot Chart

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

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

Not applicable

Re: Accumulation - Pivot Chart

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

MVP
MVP

Re: Accumulation - Pivot Chart

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.

Community Browser