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}
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 