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

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Watch MrExcel Video

Forum statistics

Threads
1,095,385
Messages
5,444,150
Members
405,269
Latest member
Kjtakke

This Week's Hot Topics

Top