3 Replies Latest reply: Dec 3, 2014 9:52 AM by saurabh singh RSS

    Table Chart Previous Year Month

      Hi,

       

      I need to create a expression in a pivot table that calculates the month previous year amount, but I need this to work when you select various and different Year_Months:

       

      Example:

       

      Selected: 201410, 201401

       

      Table:

      YearMonth 201401 201301  201410 201310

      Product A   10000     8000     5000     2700

       

      and has to be dynamic...

       

      Thanks in advance,

       

      Francisco.