Top n, Others, and Total in Data View

Efraim
Efraim Customer
Name Dropper First Comment Board Developer Level 200: Building A Planning Solution in Board
edited January 15 in Platform

Hello,

How can I display the following in a data view:

  • Top 5 Clients with its total which is "Top 5"
  • Total of the remaining clients in the "Others"
  • Lastly, the Overall Total in "Total Revenue"

I think I can do this by having 3 separate data views (Top 5, Others showing Totals only, and then Total Revenue also showing Totals only) but I can't find a way to get the Others (Total Revenue - Top 5)

Answers