GETPIVOTDATA formula to identified FILTER from slicer

[patsfan]

Can someone assist? I have a pivot table with two slicers and I am wondering if there is a formula to identify the chosen filter in one of the slicers? Optional...if more than one filter is chosen, it would return "Multiple Filters Selected". Thanks

 

[patsfan]

Sorry to repost but since there have been no responses, I am assuming my desired outcome cannot be achieved. Does anyone know a workaround while still using a PT slicer? If not, I guess my only other option would be to remove the PT and summarize my data using a list box control to choose my attribute, along with a variety of other formulas to summarize the data.

 

[dan_l]

http://www.powerpivotpro.com/2010/12/another-way-to-get-and-use-slicer-values-in-formulas/


http://www.excelguru.ca/content.php?263-Retrieving-Selections-From-A-PivotTable-Slicer


Do either of these help?

 

[vasim]

May be you can apply the same criteria in the pivot as well in the "Report filter option"

and give an = sign Depending on it....

 

[patsfan]

AWESOME! Thanks guys for you responses, The "powerpivotpro" link idea even works without Power Pivot.

 

[Pearl_022]

I am trying the same but not working. Please advise how I can achieve this. I mean to say is when i use the formula ="Selected Date:"& B2.

 

[Chihiro]

@Pearl_022
This is such an old thread. There has been many changes to data model engine and available DAX since then.
I'd recommend starting a new thread detailing how you have set up your workbook and what you are trying to accomplish.

Also, as a new member. You should start by reading below link. It will help you get the right help faster.
Site Rules - New Users - Please Read | Chandoo.org Excel Forums - Become Awesome in Excel

 

[Pearl_022]

Thank you Chihiro. I have posted my question but haven't got any respond yet.