Pivot Table to Read MDX Query based on Cell

[maheshrk81]

Hi All,

I have a Pivot table created with Cube connection. I have a tab where we can go and select the desired selections using slicers/dropdown/etc.
Based on the selections, in one particular cell, i will create a MDX query. Is there a way that query is taken and Pivot table refreshes using the MDX query automatically.

Thanks,
Mahi​

 

[Zunit]

You could create a VBA 'event' so that when the value in the cell changes it refreshes the pivot table.

 

[maheshrk81]

Thanks for the quick reply Zunit. Can you please provide me the VBA code and let me know how to connect the Pivot table to that code.