Help with Quicksight function

Hello Community,

I am trying to achieve the following calculation from excel in Quicksight.
Please note column C is the running sum of column B.
Can someone please help me calculate column D which is sum of column B - each value in the row c2 and so on.

Thank you!

Hi @Ajinkya_Bangale,

Please refer to the Calculations below:
Cumu_Sales

runningSum(sum(Sales),[{Order Date} ASC])

Total_Sales

sumOver(sum(Sales),[])

Diff_Calc

{Total_Sales}-{Cumu_Sales}

image

Did this answer your question? If so, please help the community out by marking this answer as “Solution!”

Thank you Salim.
This was super helpful :slight_smile: