Beast Mode for Top 20 then Other


I am creating a table to rank sales by each company for the last 3 years and totalling the revenue. 

I would like to show in a table the Top 20 companies by Total 3yr Revenue with the remaining companies aggregated in a row named "Other" rather than the individual company names.

I was trying a beast mode to rank each company by their individual total revenue divided by the total revenue for the entire dataset for a percentage, but I can't seem to get it to work.

Please help! I know how to do this with properties in a pie chart, but not in a table. 

Thank you in advance!

Example table:

Company2015 Rev2016 Rev2017 RevTotal Rev
Co A$1,000.00$1,000.00$1,000.00$3,000.00
Co B$900.00$900.00$900.00$2,700.00
Co C$800.00$800.00$800.00$2,400.00
Co D$700.00$700.00$700.00$2,100.00
Co E$600.00$600.00$600.00$1,800.00

Best Answer


  • user069835

    Trying to do the same thing. Is there an updated solution to this that doesn't require the ETL to be updated? 

  • jaeW_at_Onyx

    No.  You can implement in a DSV (dataset view) but there is no native way in analyzer.


    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"