Change PivotChart Aggregation Methods using Excel Slicers
With disconnected tables in Power Pivot* we can change PivotChart aggregation methods using Excel Slicers. It allows us to create Pivot Charts where the user can select different views of the data like so: It’s handy if you have limited space in your report or dashboard, as it allows you fit two charts into one. …