Don't show all Pivot table subtotals


T

tlc

I have data that includes amounts and dates. When I put these items in a
pivot table, I want the amounts subtotaled but not the dates. My data is:
Activity/Vendor/Contract amount/Contract begin date/contract end date

There are multiple vendors under each activity. So I want to use a pivot
table to summarize these activites. I want the amount for each vendor listed
and included in subtotal. I want the begin and end date for each vendor
shown but not subtotaled. Is there a way to show some subtotals but not
others for the same row data?
 
Ad

Advertisements

S

Sean Timmons

Right-click within each column of data you don't want subtotals for, select
Field Settgins. select None under the sutotals section.
 

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

Top