I am really far in the retreival of data from a pivot table, i am using the concatenate funtion together with getpivot data to get my data from the pivot, as shown below:
=GETPIVOTDATA(FloorCareSalesAnalysis,CONCATENATE($I$38," ",$G$37," ",$D$6," ",$D$7," ",E38," "))
where the different cells contain changeble values by means of comboboxes. I use a Named Range to refer to the pivot. However, i want to use also here the cell content of a particular cell, so i can determine which pivot table the formula has to look to. i cannot get it running with a normal cell reference like below, because then the formula expects the pivot table there directly, see below.
=GETPIVOTDATA(E5,CONCATENATE($I$38," ",$G$37," ",$D$6," ",$D$7," ",D38," "))
is there a way to make this also variable, in other words dependable on the content of cell e5 i refer to different pivot tables?
I know this is a though one, but i hope you can solve.