Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I need urgent help on this.
Currently I have a table:
Date, Product Type, Product Name, Amount
and other fields.. but mainly focusing on these fields..
I have filtered on the dimension to show the top 5 product type on aggregated amount, however, it returns more than 5 product type. May I know how to fix this please? Thanks.
Hi,
Try the following
1. Use dimension limit.
OR
2. Use calculated dimension.
=Aggr(Only({<[Product Type]={'=Rank(Sum(Amount))<=5'}>}[Product Type]),[Product Type])
OR
3. Use Expression like.
Sum({<[Product Type]={'=Rank(Sum(Amount))<=5'}>}Amount)
Thanks,
Nitin.