Dynamic TopN Reports Using PowerPivot V2!
Folks, the combination of slicers and DAX is just. amazing. Do you SEE that picture above?
If the consumer of the report wants to change it completely, and see Top 10 Customers by Total Paid (Sales), it's two quick slicer clicks:
Read more Part 3... (by Colin Banfield)
Read more Part 4... (by Colin Banfield)
Tags: excel, powerpivot, slicer, tabular