5 Replies Latest reply: Feb 5, 2016 12:10 PM by Gysbert Wassenaar RSS

    If sheet filtered by month, one chart should be filtering that month -1

    patrico mesri

      Hi community.

       

      I have a sheet where I have 2 pie charts and a big filter pane at the top with "Month" selection.

      If I hit November in the filter, both charts will filter November. I need to be able to make a comparison with the previous month.


      So, if I filter November, the other chart should be showing October.

      If August selecter, the other chart should be showing July, etc.

       

      "Mes" is Month in spanish.

      Untitled.png

       

      Thank you in advance.

      Regards.