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.