Line Chart not showing Top N

[gnmq]

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.

[NitinK7]

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.