Is there a way to show the difference between the difference dimensions? I have a pivot chart with two dimensions - Dimension A goes along the side and has 2 values. Dimension B goes along the top with many more values.
I'd like to show. on the bottom, the difference between the 2 values of Dimension A for each Dimension B.
Currently, it looks like this:
1 2 3 4 5 6 7
A1 20 30 40 50 50 60 80
A2 15 20 25 30 35 45 50
I'd like another row on the bottom that will show this: