3 Replies Latest reply: Aug 19, 2014 6:31 AM by Gysbert Wassenaar RSS

    Fix column in a diagramm sum table

      Hello together,

       

      i have problems with a Diagramm Table Sum.

       

      In the following you see the filtes of the table:

      Year
      2014
      2013
      Nature
      Actual

      Forecast I

      Forecast II
      Last year

      Month

      MonthMonthMonth
      1234
      5678
      9101112

      Here you see the Diagramm Tabel Sum

      ActualForecastLast Year
      Revenueit should Show always the actual figures (filter ofit should choicable for the Forecast I oder IIit should Show always  the last year filter
      Forecastit works
      Gross Margin

       

       

      I Need help of the columns. The first colum works, if I click a other filter (eg. Forecast 1) it Shows the actual. But in the second column it Shows me the choicable Filter (eg. last year, forecast I or forecast II).

       

      How can I fix the forecast column to Show me only forecast I or forecast II?

      How can I fix the Last year column, that it Shows me always the Last Year Filter.

       

      Does anyone can help me.

       

      Thanks.

       

      Jörn