I have a Pivot table that is influenced by slicers and report filters.
| launch | dates | company | dev | prod | total |
|---|---|---|---|---|---|
| a | 1 | aa | x | c | 32 |
| a | 1 | bb | x | v | 123 |
| a | 2 | cc | y | c | 34 |
| b | 1 | dd | x | v | 12 |
| b | 2 | ee | y | c | 43 |
I wish to achieve the functionality where depending on the selected value of Slicer A, it would change the value of Report Filter B and switch the Column Selection.
For Example, When I select launch date='1' on the Slicer, I would like it to filter the company to only Company "aa" & "bb", and switch dev column to prod column in the pivot table. Should I change my selection on the slicer, it would be coded to change the company filter and toggle between prod and dev column.
Appreciate any ideas here! the whole purpose make the report dynamic and automated in some way.