How to show weekly variance as a new column

We are trying to show the week over week performance, and would like show the change in Revenue as a 3rd column. See attached.
 
is there a way to accomplish this on the fly using the pivot? 

Attachments:
Weekly Variance.png

1 answer

Public
Dmytro Zvazhii Flexmonster April 10, 2018

Hello Ankit,
Thank you for your question. Please find the jsfiddle example here – http://jsfiddle.net/flexmonster/a7Ljxbry/. The general idea to achieve such behavior is to set Difference aggregation for Revenue measure and also create calculated value from sum(Revenue).
Please let us know if it works for you.
Regards,
Dmytro

Please login or Register to Submit Answer