Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

MATRIX (TOPN + GROUPED ITEMS)

I have a database with 10 item and its respective values.

 

I would like to know if there is a way to show in a matrix the TOP3 products (it is already done by TOPN and RANKX), and group the another ones (7 products in this case), creating a new category ("Another Products") and summing its values.

This new category must be dinamic, because TOP3 can change according the filters used on the dashboard.


The resultant matrix would be like this:

 

PRODUCT                                 VALUE
TOP1                                             X

TOP2                                             Y

TOP3                                             Z

ANOTHER PRODUCTS                 SUM

No Replies