Issue with Pivot filtering

Hi Folks,

Thanks for looking into my question.

I am trying to apply top 10 filter on a pivot which has a nested data. I want the same filter to be applied to data at previous hierarchical level too.


In the attached file, I am trying to find the sales are profit for
Each region aand group id but only where run_id is minimum.

Example the pivot should display


East ---- 1123 ------ 12 ---------------3434 ----------- 858.5
---- 1243 ------- 43 --------------1300 ----------- 260
East total

West ----- 1123------- 11 -------------- 34243 ------ 6848.6
------1129 ------32 --------------- 5467 -------- 1366.75

Please help...My job depends on this

Thanks in advance.

Create a helper column with this formula: AGGREGATE(15,6,$C$2:$C$15/(($A$2:$A$15=A2)*($B$2:$B$15=B2)),1)=C2, then put this new field in Filters.