capture subtotals, slicer information from VBA?

[murd]

in a pivot table i would like to capture the subtotal of a person based on if the the slicer name is the same as the column name

if the slicer name = column name then retrieve that subtotal of that person.....how can I go about achieving this in vba in a particular cell?

thanks.

[murd]

anyone have a clue

[murd]

............................

[romperstomper]

Can you provide a sample workbook showing precisely what it is you want to test. It's not 100% clear to me yet.

[murd]

sample.xlsx

Here is the attached sample data...i would like to know how I could show the # and % of subtotals if the slicer name is the same as the column name aside from the pivot table.

Thanks for the help

[romperstomper]

There appear to be multiple subtotals for each slicer value so which values are you actually trying to retrieve?

[murd]

right! Now if I click on the slicer item(any single name) I only want the subtotal of that same name(from the slicer)...so I only need the subtotal of whatever the slicer name I click on

[romperstomper]

Isn't that just the grand total, since your slicer field is not in the table?

[murd]

No that would be all of the patients combined (visited+responsible = grand total)
I would like to have (the visited that WAS ALSO responsible so...slicer name = visited provider name) which is subtotal.[COLOR="Silver"]



for example....if i click John doe for the slicer item....in the pivot table John doe(visited provider) should have a subtotal of #25...and %25 out of grand total 100. so i would like to only show John doe's subtotals

[romperstomper]

OK, I see. The simplest way is to add your slicer field as a report filter so that the selected value appears in a cell, then you can refer to that cell in a GETPIVOTDATA formula. See attached version of your file.

[murd]

THANK YOU VERY MUCH!!!!! you save further headache