5 Replies Latest reply: Sep 28, 2012 8:59 AM by MARCOS SALO RSS

    How to compare field/columns in a pivot table (e.g. Quarter on Quarter)

      Hello,

       

      I am trying to achieve a dynamic comparison between fields in a pivot table (quarter on quarter in this specific case).

      I have tried to build a set analysis but, it did not work.

       

      Please note that quarters (Q1, Q2, Q3 and Q4) are set with a mapping reading the date.

       

      Below is my data with no calculated expression.

       

       

      And following image should be the final result where the trend between current and previous quarter is shown.

       

       

      Thank you for your help.

      QVMM