Excel 2010 - Display only subtotals in a pivot table

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
epmmisAsked:
Who is Participating?
 
ShumsDistinguished Expert - 2017Commented:
Hi,

  1. Right Click on Every Group in Pivot Table
  2. Click Expand/Collapse
  3. Select Collapse
Before:
BeforeAfter:
AfterHope this helps
0
 
ShumsDistinguished Expert - 2017Commented:
No Comments been added after last solution provided.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.