having pivot table show only the subtotals for the daily averages

L

libertyforall

I need to have the pivot table show the totals only for each day. I
would like to click and past the entire years daily average only
instead of having to manually copy and past all 365 rows since it
shows each 1/2 hour increment plus the daily subtotal.
 
D

Dave Peterson

Maybe you can select that field, rightclick on it and use Group And Show
Detail|Group
and then group by day (unselect any that excel selected for you).

If you have any text (including empty cells) in that date/time range, this won't
work. It has to be dates/numbers.
 

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

Doughnut Chart linked with the slicer in the pivot table 0
Listing only sub totals in pivot table 1
Using subtotals in Pivot table formulas 0
Extract subtotals (averages) from Pivot Table 1
Grouping daily transactions by month (using pivot tables), acrossyears 1
Pivot Table Chart Question 0
Pivot Table 1
Average in a Pivot Table 3

Top