If anybody can help me with a slightly complicated problem regarding pivot tables it would be GREATLY appreciated!!!
I am trying to find a way to have my pivot table display data shared by multiple groups without displaying a "blank" for the groups that do not have data (because the data is already being shown for the group?
Example:
Data sheet view
% Spent
86.71%
27.34%
47.16%
93.69%
99.75%
0.00%
49.52%
20.66%
0.00%
0.00%
0.00%
22.30%
35.08%
100%
*Note the difference in spacing is due to the fact that there are multiple groups represented (bigger spacing = group or 2 or more)
Pivot table view
% Spent
86.71%
0.00%
(blank)
35.08%
(blank)
100%
22.30%
93.69%
(blank)
20.66%
(blank)
0.00%
0.00%
99.75%
0.00%
(blank)
(blank)
49.52%
27.34%
(blank)
(blank)
47.16%
(blank)
(blank)
(blank)
*Note the blanks represent where there is not data due to the fact the data is already represented on one line for the entire grouping causing the remainder of the group to show as blanks.
I have tried merging cells into one for each group but had no success. Help!!
UPDATE
I managed to find somewhat of a workaround to the problem by adding quotes in the blank cells. It adds dashes ex. -- , but looks much better than those nasty little "(blank)s" that were showing up before. If anbody can think of something else I'd be more than happy to hear.....
Bookmarks