It's been a long time but i am back using Excel so i find myself back here! I have created a report workbook for users that gives them a control page with several slicers. The slicers update pivot reports on each sheet. The pivot tables have been added to the data model so that a single slicer can be linked to more than one pivot.
What my users wants to do is amend the slicers to a certain selection and then double click the grand total on the pivot table to see the data rows that make up the grand total number.
Unfortunately, Excel presents the message "You cannot use Show Details on a Grand Total value when a filter is applied to the row or column fields. To use this command, remove the filter"
But the whole idea of the workbook is so that they can segment the data they want and then interrogate the detail. Removing the filters would defeat the point.
Any ideas on a solution? Example attached
Bookmarks