All Other line in Top 10 pivots and tables
Give us the ability to add an "all other" line when we select a Top 10 style pivot table or table so the totals are accurate. Many managers are ok with just looking at top 10 customers for example, but want to see the "all other" line so the total sales match.
YES. No proper analysis without this. Been working around the missing feature for the last 10 years. About time that it got implemented.
Josh Blackman commented
Yes! Yes! Yes! This is so important and a key use case for anyone who cares about good data analysis. My workbooks are needlessly complex right now vecase this feature doesn’t exist. Please fix.
This needs to be addressed!