Listing only sub totals in pivot table

L

libertyforall

Is there a way once the data has been put into a pivot table to only
list the sub totals instead of displaying all the data? I need to copy
all the subtotals for the daily averages only and past in either
seperate columns or a seperate tab or excel doc. Otherwise, i would
have to copy and past all 365 daily values.
 
L

libertyforall

Is there a way once the data has been put into a pivot table to only
list the sub totals instead of displaying all the data? I need to copy
all the subtotals for the daily averages only and past in either
seperate columns or a seperate tab or excel doc. Otherwise, i would
have to copy and past all 365 daily values.
Click to expand...

On the pivot table I am copying and pasting the daily totals. Each of
the daily totals for all days about 370 total I would like in one
document.
 

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

Sub projects added as read only in Master file which are saved on sharepoint 1
having pivot table show only the subtotals for the daily averages 1
Dealing with a Pivot Table (when I don't want to) 0
SUM & OFFSET & PIVOT TABLE?? 0
Pivot table report invalid 0
Pivot Table Counting Text Issue 0
Consolidation Table from Different Excel Tabs with Different Format 1
Pivot Table: summarizing two different ways 0

Top