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

    Variance by year on expression



      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 %

      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.