Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Top N on multiple fields

I have a table with follwing 4 fields 1- CAT 2- SubCAT 3- DetailCAT 4- Sales   I have created a Bar chart with drill down on Cat--> SubCat-->DetailCat on X Axis and value is SUM(Sales)   I wa...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Anonymous

 

No, it can't be achieved.

 

For numeric field, like Sales, it's not possible to add TOP N filter.

 

For different level CAT field, we can apply a TOP N filter. However, once you apply a TOP N filter on one level, all other levels are fixed, which means you can't make each CAT level keep only TOP N entries when drill down. 

 

 

Regards,