12 Replies Latest reply on May 13, 2020 9:48 PM by Soumitra Godbole

    How to combine multiple filters into one filter?

    Hamad Alaqeel

      I have the following data:

       

      WeekSpain 2018
      Spain 2019Spain 2020Italy 2019
      Italy 2020
      112334311
      232525515
      342712310
      45101217

       

      And I've created a line chart were it combine all the columns in one chart. But, for the filters, instead of displaying Spain 2018, Spain 2019.. and so on. I want to to be Spain and Italy only. And if I choose one or both of them it will give me all the years for that country.

       

      So, if I choose Spain it will display all the years for Spain; each years has it's own line.

       

      How can I approach this, I'm lost..How to combine two filters into one?