How would I get the top 5 or 10 spends from one column by another column.

iamjackier

Example: What is the top 5 spend(column) by Submission Category (column). There are two columns involved. Thank you!

NicoLHC

@iamjackier do you have a sampke screen shot?

iamjackier

Screenshot 2024-09-13 at 10.11.55 AM.png

Hi Nico, thank you for reaching back! This is an example, I want to get the top spend by either vendor, category, or IT Vertical, if there's any way I can obtain top total spend by vendor and it vertical, etc. that would be appreciated. In general I want a top 5 or 10 spend by either or, I just don't know how to obtain that so it can be reflected on a dashboard that shows top 5-10 spends. Hope that makes sense. @NicoLHC

NicoLHC

@iamjackier i prepared the first part of the solution formula….

=RANKEQ([Number Column]@row, [Number Column]:[Number Column]) + COUNTIF([Number Column]$1:[Number Column]@row, [Number Column]@row) - 1

NicoLHC

@iamjackier Part2 Dashboard =INDEX(COLLECT([2024 PO Amount]:[2024 PO Amount], Rank:Rank, 4), 1)

NicoLHC

@iamjackier Part3 Dashboard Ideas