Forum Discussion

shareezsaleem's avatar
shareezsaleem
Helper III
1 year ago
Solved

Show Only Top N In Column Level

Hi All, I have a matrix like below: Level 1    WBS1 WBS2 WB3.....WBS723 MACHS   12       34       44 PAX         28       44       22 ELEC.       60       32      11 Total       100     110    ...
Need Help
  • kushanNa's avatar
    kushanNa
    1 year ago

    Hi shareezsaleem 

     

    did you try to use the Top N filter on the filter panel? 

     

     

     

shareezsaleem's avatar
shareezsaleem
Helper III
1 year ago

See the real data

I want to reduce the column to top 5 based on the rank of WBS (which is the sum of values)

 

WBS Rank Matrix:

WBS Rank = IF(HASONEVALUE(Finance[WBS_Rev.]),RANKX(ALL(Finance[WBS_Rev.]),[Actual MTD],,DESC,Dense))