How to remove the individual count under Subtotal in Excel Pivot Table with different rows count values

vrsharma

New Member
Joined
Aug 4, 2019
Messages
18
Office Version
365, 2016
Platform
Windows
Hello Team,

I want help in removing individual count under subtotal in Excel Pivot table, where rows count contains different values. The value in row count is not similar.
I just want to show subtotal not row count. I am currently using Excel 2016 version.

Below is what my pivot table data looks



Below is what I am expecting my pivot table should look



Thank you in advance
 
Last edited:

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Watch MrExcel Video

Forum statistics

Threads
1,090,245
Messages
5,413,284
Members
403,472
Latest member
ArtisticOwl

This Week's Hot Topics

Top