3 Replies Latest reply on Jan 8, 2019 4:01 PM by Hari Ankem

    Side-by-Side comparison of 'Year' filter

    Douglas Brockbank

      On my 'Year' dimension, I selected 'Show Filter' and have multiple years I can select for my 'Line' chart. The default year is 2018. However, if I select 2017, I want it to create a new chart so I can see a side-by-side comparison of 2017 and 2018. However, instead it keeps the one chart and shows an updated Line chart with 2017 and 2018 data.

       

      How can I modify my worksheet so that when I select a previous year (e.g. 2017), it automatically creates 2 charts with 2017 on the left and 2018 on the right?