• 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

  • Year on Year example.xlsm
    667.1 KB · Views: 8
I believe the easiest solution is using a powerpivot with a measure sum of pax of last year. Example attached. See if that is okay.
 

Attachments

  • Copy of Year on Year example-1.xlsm
    987.2 KB · Views: 17
Back
Top