4 Replies Latest reply: Apr 5, 2012 9:50 AM by jagan mohan rao appala RSS

    Variance by year on expression

      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 straight table or a pivot table will the following information

       


      20112010Var  €Var %
      Sales



      Gros margin



       

      I have place year(date) as a dimnesion calculated in the load and Sales and gross margin as expression

       

      I'am now wondering how to calculates variances ?

       

      Must be simple but i have spend time on that without any solution

       

      Many thanks in advance.

       

      Lionel