This content has been marked as final.
Show 1 reply
-
1. Re: Table down calculation for an existing table across calculation
Patrick A Van Der HydeNov 26, 2014 11:00 AM (in response to Austin Barry)
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