Post by Rob Collie
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.
This Came Up Recently…
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:
The Top 10 / Top N Value Filter in Pivots: Get to Know It, It Does Amazing Things
But If we set that to show us the top 10 customers, it shows us JUST those 10 customers:
OK cool, we see those top ten customers, and that they collectively purchased $132,026 of stuff from us.
But we want to ALSO see how much the OTHER (non top 10) customers are worth too.