0 Replies Latest reply: Apr 3, 2012 7:29 AM by lionel925 RSS

    Evolution rate as a calculated dimension

      Hello

       

      First of all I am a beginner.

       

      Let say that we have a table with 6 fields : Customer, customer familly, ,order number, year,  Sales, gross margin

      The goal is to produced a bubble chart having as axis : Turnover increase rate (Selected year versus the year before), gross margin rate (gross margin / sales)

      The bubble should represent the gross margin value., for a given customer

      The chart should change if a customer familly is selected or changed

       

      I have struggled a little bit with nested agreagation (aggr), and must adminted that i could make it work.

       

      Must be classic and stupid

       

      Many thanks in advance.

       

      Lionel