topic Re: RANK SET ANALYSIS in App Development

RANK SET ANALYSIS

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

I need to show the top 10 using rank with a set analysis. I just need it to focus on the item type : inventory Item.

Goal :

1. Rank show only top 10. Rank by Subtotal

2. Colums : Item Name, Subtotal, Total Unique Purchase Orders.

MayilVahanan — Wed, 03 Jan 2024 02:01:21 GMT

Try like below

If rank is based on item Name, then in Aggr function, instead of subtotal, try like below

=Aggr(Rank(Sum(Subtotal)), [Item Name])

KevinJ — Thu, 04 Jan 2024 01:12:42 GMT

I forgot to include the ranking would also be a set analysis of Currency = PHP, and Item Type Inventory Item. How would that be possible?

KevinJ — Thu, 04 Jan 2024 02:06:47 GMT

I forgot to include the ranking would also be a set analysis of Currency = PHP, and Item Type Inventory Item. How would that be possible?