Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Data be like-
DIM1 | sales |
A | 12 |
B | 11 |
C | 32 |
A | 22 |
C | 21 |
Hi,
I need to Find out top 2 Dimensions based on the Sales (sum(sales)). and need to show these two top Dimensions.
Top 2 Dimensions |
A |
C |
Hi,
You can try use this expression =if(aggr(rank(sum(sales)),dim1)<=2,dim1) on data dimensions in filter pane.
Regards