• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Linking 2 slicers conditionally

Christof

Member
Hi,

I was wondering if the following is possible.
On the attached file I want to do a true year-on-year comparison.
So if I select a date period using the slicer for a departure year, it would apply those filters to pivot table one, and then pivot table two would show the equivalent period last year for the equivalent departure year.

Eg: if i select Confirmed Date 1st Jan 2019 to 28th Feb 2019 and Departure Year = 2019,
it will display the above on pivot table one, but on pivot table two it will be showing Confirmed Date 1st Jan 2018 to 28th February 2018 and Departure Year = 2018.

Similarly if for the same date periods i wanted to see 2019 AND 2020, it would compare for 2018 AND 2019 on the dates in previous period (if that makes sense).

Attached sample file.

Many thanks
Chris
 

Attachments

Top