Pivot Table Subtotals

markyc

Board Regular
Joined
Aug 23, 2006
Messages
149
I have a pivot table with two Row Fields. The first row field has automatic subtotals enabled. However, about half of the data only have one piece of data for the second row field, the other half of the data has multiple data. The problem is that I do not want to show subtotals for those items that consist of only one row, but I do want subtotals for those that have multiple rows.

RF1 RF2
A 1
A 2
B 1
C 1
E 1
E 2
E 3

Using the above data as a simple example I want there to be subtotals for "A" and "E" only. Please note that the Data -> Subtotal is not useful because I also have a few Column Fields and two Page fields.

Any help is appreciated.

Thanks,
Mark
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Sorry, you can't selectively apply Subtotals (all or none); however, if your PivotTable is as simple as suggested above you could create 2 Calculated Items that do the same thing.
 
Upvote 0

Forum statistics

Threads
1,224,882
Messages
6,181,549
Members
453,053
Latest member
ezzat

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top