Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
- Create a Pivot table
- Dimension is Customer
- Sum(Sales) and running total are the expressions (see attachment previous post)
- Sort:
Grtz Fred
Hi Daniele,
See attchm.
Grtz Fred
- Create a Pivot table
- Dimension is Customer
- Sum(Sales) and running total are the expressions (see attachment previous post)
- Sort:
Grtz Fred
Hi Fred,
thanks for your help
Daniele