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
I have the same question (0)
