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!
|Company||2015 Rev||2016 Rev||2017 Rev||Total Rev|