Hi,
Here is my scenario:
I have a pivot table with data being pulled from a database (in my case, Analysis services cube). Then I have another Excel list. I want to filter my pivot table using the data from the Excel list.
For example:
On my pivot table, i have all customers plus their invoice amount of the an specific month. The user have a list of x number of customers that he wants to filter on. Instead of filtering one by one, i would like to use the list as starting point.
You may say that i could use a VLOOKUP or something, however, i want the filter to be applied on the pivot table so if i want to change the month selected, my pivot table will refresh the data with the information from the database.
Here is my scenario:
I have a pivot table with data being pulled from a database (in my case, Analysis services cube). Then I have another Excel list. I want to filter my pivot table using the data from the Excel list.
For example:
On my pivot table, i have all customers plus their invoice amount of the an specific month. The user have a list of x number of customers that he wants to filter on. Instead of filtering one by one, i would like to use the list as starting point.
You may say that i could use a VLOOKUP or something, however, i want the filter to be applied on the pivot table so if i want to change the month selected, my pivot table will refresh the data with the information from the database.