Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
Thank you a lot, you are really help me)
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
Hi,
Please advise How would you have done it in the Back End script? Please share.
Kind Regards,
Sanele Zwane