Displaying Top N, Bottom N, and "All Others"
If We Use Excel's Built-In Top N Filter to See Our Top 1,000 Customers, It Hides the Other Customers Completely. But Using DAX, We Can Just "Split" the Audience into Two Groups.
Hey, I absolutely ADORE the TOP N filter capability offered by all Excel Pivots. It kicks major booty and we use it all the time: