I'd like my Pivot Table to show a sub-total for rowfields that have more than one value but no subtotals if there is just one entry.
For example, a current table might show:
California II
California Total
New York II
New York Total
Illinois II
.........III
Illinois Total
Idaho II
.........III
Idaho Total
I'd like it to show as:
California II
New York II
Illinois II
.........III
Illinois Total
Idaho II
.........III
Idaho Total
I have some code that hides rows if there is just one value, but I'd prefer to have something that changes the actual pivot table.
Bookmarks