G
Garron
Hi there
I have been trying to access the values the user has selected from a pivot
table. On a Double Click of the pivot table I need to check the current
dimensions and the values they contain in order to run a second query to
display lower level data.
I can obtain the value where the user double clicked by using the following
PTable.Selection.Item(0).Value
However how would I get the value of the page values that have been selected.
Thanks in advance
Garron
I have been trying to access the values the user has selected from a pivot
table. On a Double Click of the pivot table I need to check the current
dimensions and the values they contain in order to run a second query to
display lower level data.
I can obtain the value where the user double clicked by using the following
PTable.Selection.Item(0).Value
However how would I get the value of the page values that have been selected.
Thanks in advance
Garron