Rank with set analysis 2 dimensions

[KevinJ]

I have this dimension measure but it doenst show anything.

=aggr(if (rank( total sum({$<[Item Type]={'Inventory Item'}, Currency = {'PHP'}>},[Subtotal]))<=10,sum(num([Subtotal],'#,##0.00'))),[Item Name])

I want to have the top 10 only with focus on PHP and Inventory Item. 

What seems to be the problem of my code?

[F_B]

Hi @KevinJ ,

the issue with your expression lies in how you're applying the AGGR and the RANK function within your set analysis, try this:

=aggr(
if(
rank(
sum({$<[Item Type]={'Inventory Item'}, Currency={'PHP'}>} [Subtotal])
) <= 10,
[Item Name]
),
[Item Name]
)

Hope this is what you were looking for