Retrieving Selection From A PivotTable Slicer
by, 2012-05-02 at 07:52 AM (19612 Views)
After discussions with a friend the other day, I thought it might be worth pulling together an entry to show how to get the selected item from a PivotTable Slicer into a formula. This approach allows you to drive dynamic chart titles, or based other logic off a slicer as well.
You can find the full aticle at: http://www.excelguru.ca/content.php?...otTable-Slicer