7 Replies Latest reply: May 26, 2014 6:03 AM by Basavanna SV RSS

    How to make a chart function for both local and global filter ??

      HI All,

       

      I have a chart where it has two filter, local - which is local only to the chart (I have used alternate states for this) and i have one more global filter for the sheet for all the charts and pivots.

       

      But whenever I select the GLOBAL filter the chat which I have used alternate state(or the chart which has local filter) data is not changing based on the selection.

       

      Please let me know your thoughts on how to make the chart respond for LOCAL and GLOBAL filter.

       

      Thank you,

      Bas