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?
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?