Cumulative sum(sales)

[bharani8]

Hi Team - I need to have the cumulative sum(sales) in descending order and their respective %. Attached is the sample data and qvw Attached.. Plz Help !

[Anonymous]

Thank you a lot, you are really help me)

[shiveshsingh]

You can try below in script to get cumulative sum in script itself

if(Date>=previous(Date),rangesum(sales,peek(New_Sales)),sales) as New_Sales

[skzwane01]

Hi,

Please advise How would you have done it in the Back End script? Please share.

Kind Regards,

Sanele Zwane