Top n, Others, and Total in Data View

Efraim

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)

Helmut Heimann

Hi @Efraim ,

you could accomplish that by using Nexel's Crossview.

Have a look at our manual for further information

https://help.board.com/docs/nexel-formula-editor

Be sure to name your dataviews in the screen so that Nexel can address them correctly.

Best,
Helmut