Excel 2010 - Display only subtotals in a pivot table

epmmis
epmmis used Ask the Experts™
on
I have an excel pivot table that has subtotals
Subtotal is at the top

Label                   Count of upd_Apps   Sum of upd_Apps
upd_Apps             5                                       499
App1                      1                                        53
App2                      1                                        14
App3                      1                                        80
App4                      1                                       297
App5                      1                                         55
Label                   Count of upd_Apps1   Sum of upd_Apps1
upd_Apps_1                          3                                 565
WINAPP1                          1                                 45
WINAPP10                         1                                131
WINAPP11                          1                                389

Is there a way to hide the detail e.g. App1 or WINAPP1, and display just the subtotal lines?
If not, I will use sumif and countif functions instead of the pivot table.

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Managing Director/Excel VBA Developer
Distinguished Expert 2018
Commented:
Hi,

  1. Right Click on Every Group in Pivot Table
  2. Click Expand/Collapse
  3. Select Collapse
Before:
BeforeAfter:
AfterHope this helps
ShumsManaging Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
No Comments been added after last solution provided.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial