View RSS Feed

The ExcelGuru (Ken Puls) Blog

Retrieving Selection From A PivotTable Slicer

Rate this Entry
0 Comments
by
Ken Puls
, 2012-05-02 at 07:52 AM (65789 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

Submit "Retrieving Selection From A PivotTable Slicer" to Digg Submit "Retrieving Selection From A PivotTable Slicer" to del.icio.us Submit "Retrieving Selection From A PivotTable Slicer" to StumbleUpon Submit "Retrieving Selection From A PivotTable Slicer" to Google Submit "Retrieving Selection From A PivotTable Slicer" to Twitter Submit "Retrieving Selection From A PivotTable Slicer" to Facebook Submit "Retrieving Selection From A PivotTable Slicer" to LinkedIn

Categories
Excel , PivotTables

Comments

Gravatar by 1e2.it