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
Microsoft OfficeMicrosoft ExcelMicrosoft ApplicationsSpreadsheets