Need to Calculate last three weeks average in Pivot

[Anonymous]

Please find attached sample report

As of Date

8/29/2017

9/5/2017

9/12/2017

9/19/2017 -Current week

For these three weeks no issues 8/29/2017,9/5/2017,9/12/2017

For current week we need to do the below calculation

D51 is =AVERAGE(D6,D21,D36)

D59 is =100*((D50-D53)-(K35-K38))

Could you please give some idea how to achive this in qlikview.

[dsharmaqv]

try this link

moving average in a Pivot Table

[Anonymous]

Thanks for reply but i need to show in current week as avg of previous three week