Call Out Most Repeated Item from a Table

it15 · 2025-02-14T15:18:52.031Z

Hi, I have a table of all types of revenue (e.g., amenity revenue, room revenue, event tickets… etc.), I want to find which type repeats the most times (quantity), and also the type that has generated the most revenue (value).
What would the expression look like?

image2322×1212 385 KB

image1812×1218 316 KB

adamhholmes · 2025-02-14T15:36:10.780Z

Try something like:

Search for AccountingEntries: Grouped by type: aggregate Count: sorted by Count: first Item

And

Search for AccountingEntries: Grouped by Type: aggregate Sum of revenue: sorted by Revenue: first item

it15 · 2025-02-14T16:26:00.539Z

Genius! Thank you so much.