Sumif/Sumover - Calculation field


I’ve the below dataset and I need one more calculated field the will sum of all previous dates of Productivity based on first column(“Date”). Partition filed should be Report Date, MP, Type.

You would need to use runningSum runningSum - Amazon QuickSight

In your case it would be something like:

  [ {Date} ASC ],
  [ {Report Date}, {MP}, {Type} ] 

Thanks for the response but I’m receiving the below error.

I have to show something as like below which is highlighted in Yellow Column

Calculated field should be like the below

Hi Naren!
RunningSum will aggregate the values of productivity by the partition fields. It appears in your output you actually want running sum minus the productivity value on that row. I am sharing a screenshot that shows both a runningSum calculation as well as a runningSum minus the current value of productivity. You can see the values reflected in the table visual.

Best Regards!