Filter Pivot Table to show highest value of each parent row

[griffj]

Hi

I have a Pivot Table (created from an Excel Data Model) that shows the customer, product range (3 ranges) and total spend per product range.

What I want is to return the highest spending product range for each customer. I have tried using the 'Top Filter' in the Pivot Table but all that happens is the highest value is shown but the remaining 2 product range labels are still visible with just no value.

This is what I have using Top 1 per parent row...

Customer	Product Range	Total Spend
Customer 1	Table	5,000
	Chairs
	Accessories
Customer 2	Chairs	4,500
	Table
	Accessories
Customer 3	Accessories	2,000
	Chairs
	Tables

<tbody>
</tbody>

This is what I want....

Customer	Product Range	Total Spend
Customer 1	Table	5,000
Customer 2	Chairs	4.500
Customer 3	Accessories	2,000

<tbody>
</tbody>

Is this possible?

Any help would be great.