Sumif/Sumover - Calculation field

Question & Answer
1

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.

image
image1204×314 31.9 KB

2

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} ] 
)
3

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

image
image1573×671 19.7 KB

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

4

Calculated field should be like the below

image
image1133×729 80.8 KB

5

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.

comm_runningSum
comm_runningSum1138×739 145 KB

Best Regards!
Kellie