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.



      Thank you in advance.