Is there a way to suppress data in calculation columns? I only want to show the % difference for the total, not the line items. But since the % Diff column is a calculation, it won't let me do this. The chart below is how I'd like it to look like.
ACT | BUD | $ Diff | %Diff |
PER 1 '15 | PER 1 '15 | (Unfav)/Fav | (Unfav)/Fav |
150.8 | 152.5 | 1.7 | |
52.1 | 59.7 | 7.6 | |
20.6 | 18.8 | (1.8) | |
0.0 | (10.0) | (10.0) | |
68.0 | 69.2 | 1.2 | |
111.4 | 175.0 | 63.6 | |
0.4 | 24.7 | 24.3 | |
776.7 | 873.1 | 96.4 | |
62.0 | 63.5 | 1.5 | |
1,242.0 | 1,426.5 | 184.5 | 13% |
Is there a work around to make this work?
Thanks!
Vance
*This post is locked for comments