0 Replies Latest reply: Jan 30, 2017 11:51 AM by David Sharp RSS

    Dynamically Filter Specific Dimensions out of Bar Chart??

    David Sharp

      Barforfiltering.PNG

       

      Hi All, I am trying to set up a bar chart as above with one exception, if the bar "QQYY - Actual" is present, I don't want bar "QQYY - Forecast" to be in the chart.  In the chart, that means "Q117 - Actual"  and "Q217 - Forecast" (And higher) are in the chart.  When Q2 actual data comes in, I want the "Q117 - Actual"  and "Q217 - Actual" and "Q317 - Forecast" (and Higher).

       

      I have the following fields in the Chart:

      Dimension: [Qtr-Type] this is the field with "Q117 - Actual"

      Dimension: [Breakdown] this is the different colors within bars

      Measure: [Dollars]

       

      How can I do this??? Please and Thank you!!