Hi,
I have 3 Pivot tables with the same Dates in the columns and Products in the Rows but have 3 different values I am looking at. The report filter for each has the same list of towns that have to be the same when I am looking at the 3 values.
Is there a way to make the report filter for 2 pivot tables change to the same town in my 3rd pivot when I change my selection?
Thanks for your help.
I have 3 Pivot tables with the same Dates in the columns and Products in the Rows but have 3 different values I am looking at. The report filter for each has the same list of towns that have to be the same when I am looking at the 3 values.
Is there a way to make the report filter for 2 pivot tables change to the same town in my 3rd pivot when I change my selection?
Thanks for your help.