I am currently running a table calculation that shows the percentage difference in sales, month over month, for two sets of stores. One being the treatment group and another a control group.
I want to calculate the difference of...the percentage difference in sales month over month. Below is a snap shot of what I'm trying to accomplish.
Thanks!
Nov 26, 2014 11:00 AM
Hello Austin Barry,
So this can be done with nested table calculations. As long as the Table Across calculation is saved as a measure, it can be used within another calculation that is set to Table down.
See the attached example which uses Superstore data and shows the difference between Consumer and Corporate Sales percent differences running across.
The Dashboard on the attached view shows how this can come together in a single view as well. I have two images on the dashboard showing the setup of the Nested Table Calculation and the not so obvious drop down menu where each calculation can be selected and set to use Table Across or Table Down for computing.
I hope this helps out.
Patrick