2 Replies Latest reply: Mar 6, 2012 11:26 AM by youssouf Carius RSS

    Help - Specific line chart needed

      Hi All,

       

      I have a line chart dimensioned by

           - Time (Dates formated like 'MMM - YYYY'),

           - and a calculated dimension (3 categories based on price evolution)

                =If(aggr(avg(Price_Evolution), Part_Code)> dblPriceEvolBorne_Up, 'UP',

                If(aggr(avg(Price_Evolution), Part_Code)< dblPriceEvolBorne_Down, 'DOWN', 'STABLE'))

       

      I want to compute a Quantity Index based on a spedific date.

      So the chart will display 3 curves (related to the calculated dimension). Each curve will be equal to 100 at the specific date.

      The expression I tried is the following :

                =   Sum(Gross_Quantities) /

                Sum({$ <Year_Months={'$(=Min(Implementation_Dates))'}>}

                Gross_Quantities)

       

      The issue is that this limit the dimension of the chart to the date specify (only the Min(Implementation_Dates) appears with 3 points).

       

      Please could you help me on this?

       

      Many thanks in advance