Hi,
I have a pivot table in excel, the data in pivot table is imported from SSAS cube.
I will query the data from SQL view and store the data in an array using VBA.
The data in the SQL view and Data in Array will match. Now I will pass this array items to pivot table for filtering the data. The Code for that is;
I don’t get any errors but the array what I have is not been filtered in the pivot table. What could be the problem? Is there any alternative method to do this?
Please provide your suggestions and help me to solve this.
Bookmarks