2 Replies Latest reply on Feb 2, 2017 5:18 PM by Jayna tan

    Using a column to decide the view

    Jayna tan

      Hello,

      This is the sample of my data and the chart that it forms. So for now, we are using the month which is June, August etc to do the filtering which is the last 2 bars in the chart. I would like to use the date (1/6/2016) to derive to the month. However, because from 2013-2016 i set it to January, it will not appear because it isn't null neither is it the the selected month. How should i change it? and is there a way to use the type (Act, Plan etc) to differentiate which is to be filtered? as only the type with YTD needs to be filtered but the rest do not..