Forum Discussion
Anonymous
4 years agoNot applicable
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