Get Free Trial

How to show weekly variance as a new column

Ankit Agarwal asked on April 6, 2018

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? 

Weekly Variance.png

1 answer

Dmytro Zvazhii Dmytro Zvazhii Flexmonster April 10, 2018

Hello Ankit,
Thank you for your question. Please find the jsfiddle example here – 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.

Please login or Register to Submit Answer