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

    Evolution rate as a calculated dimension



      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.