2 Replies Latest reply: Apr 3, 2018 10:50 PM by Jomar Ebonite RSS

    Previous year calculation

    Adrian Chaves

      Hi, I'm trying to set a Pivot table in one sheet that includes Actual period and Last year period for the same dimension in order to calculate a growing percentage. However I can't get previous year information (See attached file) only for the dimension that have the actual date.

       

      I have customer in Rows, period in columns... So when I have a column saying, (e.g.) 1/1/17, the previous year information doesn't pop up.. Just the actual period data.

       

      Thanks in advance for your support.