Sumif/Sumover - Calculation field

Hi,

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:

runningSum
(
  sum({Productivity}), 
  [ {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