Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Actually, what I want to do is to set the row and column selections to row and column intersection in the pivottable. I see that if I click on Row A and Col B
the selection is fine. If I then click on Row A and Col C, the value of the Row is toggled out and the selection for the row is blanked out. Instead I want the variables to be set to Row A and Col C.
I was thinking to implement this in VBScript. But I am not able to get the context of the cell where the user clicked.
Please let me know how I can implement this - whether with VBScript or any other configuration changes.
Thanks
Sekhar
Not sure I got what you're trying to achieve but I have a couple ideas that might help you.
You can have a document level trigger on Row and Col selection then store into a variable the selection.
You can use previous selection in set analysis sum({$1} Sales) will return the sales of the previous selection.