How to access selected report filter values in Excel Pivot table from VBA code or Formulas?

[prokurors]

I have a pivot table with report filter field. I need to do some operations based on the value user selects in report filter field.
If user selects single value (or selects <code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">All</code>) - no problem to get that value. In sample video it's cell B1, but in case of multiple values are selected, this field shows just <code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">Multiple selected</code>.
Where can I get the specific reporting filter values that are selected? Can I access those values from Excel formulas? If not - can I access those values from VBA code?

Sample video
2015-04-08_1119 - Prokurors's library

PURPOSE
I want to access those values that were selected in report filter field. And do some calculation that would get values from rows (from another table) that has only values that are selected in report filter field (currently this is working when I have selected "All" or one of values, but can not get this working with multiple values selected)

 

[IBCB007]

I want to access those values that were selected in report filter field. And do some calculation that would get values from rows (from another table) that has only values that are selected in report filter field (currently this is working when I have selected "All" or one of values, but can not get this working with multiple values selected)

[/FONT][/QUOTE]

So the easiest way to get the values to display is to right click in the table, select display options, select the display tab, and check the Classic pivot table design. this will allow drag and drop in the table, but the view will let you display the current filter settings.

 

[prokurors]

So the easiest way to get the values to display is to right click in the table, select display options, select the display tab, and check the Classic pivot table design. this will allow drag and drop in the table, but the view will let you display the current filter settings.

Hmm... I don't get how this suggestion is related to my question

But, I've got answer for this question on msdn forum, You can find the answer here:
https://social.msdn.microsoft.com/F...exceldev#cd8cbaad-434f-455c-a712-dc6c2d9905ed