hi,
I'm looking for expect who could help me writing a macro that will automatically update a pivot table based on one or multiple selection in cells that are all looking within the same pivot field.
I succeeded to do it on 1 field, but it seems there's a limitation that cannot be overridden. I also understood that there might be alternative solution, less direct to do that.
To better illustrate what I need to achieve:
the 2 selection in this example here below with the yellow background need to be filtered in one Pivot field (called here combination).
Pivot & source data are on the same sheet.
I really hope someone will be able to support me on this request that avoid me finalizing a large dashboard.
Thanks!!!
Tilou
I'm looking for expect who could help me writing a macro that will automatically update a pivot table based on one or multiple selection in cells that are all looking within the same pivot field.
I succeeded to do it on 1 field, but it seems there's a limitation that cannot be overridden. I also understood that there might be alternative solution, less direct to do that.
To better illustrate what I need to achieve:
the 2 selection in this example here below with the yellow background need to be filtered in one Pivot field (called here combination).
Pivot & source data are on the same sheet.
I really hope someone will be able to support me on this request that avoid me finalizing a large dashboard.
Thanks!!!
Tilou
