Help with Pivot Table subtotals?

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

My Pivot Table looks like
COOLANT
COOLANT 50/50
GALLONS


COOLANT 50/50 Total


COOLANT 60/40
GALLONS


COOLANT 60/40 Total

COOLANT Total






I'd lke to get rid of the "Coolant 50/50" and "Coolant 60/40" subtotal
lines. Double-clicking "Coolant 50/50" also makes "Gallons" go away. Is
there a setting or property that will do this?



Ed
 
Apologies - I tried pasting in an actual table from Word and it didn't take
too well!

But - I did find the answer: Field Settings, select None under Subtotals.
Ed
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2007 Pivot Table 5
Average of Subtotals in Pivot Table 0
Pivot Table question 4
Calculated items/fields in pivot table 2
Pivot: totals in the next column 6
Pivot table question 5
Pivot table question: Sorting the subgroup in a pivot table (whenusing the top 10 option for the sub 0
Pivot Table Help 1

Back
Top