topic Rank with set analysis 2 dimensions in App Development

Rank with set analysis 2 dimensions

KevinJ — Fri, 15 Nov 2024 21:08:24 GMT

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 — Mon, 02 Sep 2024 13:30:52 GMT

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