Call Out Most Repeated Item from a Table

[it15]

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?

[adamhholmes]

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]

Genius! Thank you so much.