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