2 Replies Latest reply on Sep 6, 2013 2:04 AM by Carlo Scattolin

    Reference line with drill-down

    Carlo Scattolin

      Hello, I have a big problem with reference lines.

      I have 3 dimensions, "year", "level1", "level2". Level1 and level2 are a hierarchy.

      I have 3 measures (measure1, measure2, measure3).

      I want to add a reference line that calculate the average of measure3 respect to year.

      When I click on drill-down, I want a reference line that calculate the average of measure3 respect to year and level1.

      I really don't know how to do. If I calculate correctly the reference line2, when I click on drill-up the program says that there is a missing field. If instead I calculate correctly the reference line1, when I click on drill-down, the resulting reference line is calculated respect year and level2.

       

      Please help me.

       

      Bye


      Carlo Scattolin