Cumulative sum order by sales

[#1]

Hi,

I have to create a table with 3 column: Customer, Sales, and a column with comulative sum. I done it with

rangesum(above(total sum(Sales), 0, rowno()))

But i have to order descending by Sales, and it don't works when I insert the cumulative sum, can anyone help me?

Regards

Daniele

[fred_s]

Hi Daniele,

See attchm.

Grtz Fred

[fred_s · Accepted solution]

- Create a Pivot table

- Dimension is Customer

- Sum(Sales) and running total are the expressions (see attachment previous post)

- Sort:

Grtz Fred

[#4]

Hi Fred,

thanks for your help

Daniele