I have a pivot table with dimensions Type , product and sum(value). I have filter object called variable with some values. The dimension name contains 2 values that is called GD and base. My requirement is when ever a user select any value from the filter object called the variable the type dimension value called the gdp in the pivot table should show as the selected value in the variable filter object.
Example: i have a value called ABC in my filter object called variable and the type dimension is GD and base. When i select the ABC from the variable filter the GDP should turn as ABC in my pivot table. This logic should work only if a user select a single value from the variable filter. Can someone help me please?