Calculated Field / Column / Item in Pivot Table

[rashidmehmood]

Hello,

I need to calucate growth from the single column data in the pivot table. I have Sales Amount data for the year 2014 and 2015 in the single column and year and month details in the different columns.


Need to create growth % column from the Sales Amount column. If I had Sales Amount data in two different columns for each specific year I could have created calculated column using this forumula (Current Year-Previous year/Previous Year). But I don't know how to calculate it when I have sales figures for both the years in the same column.

Need your help experts! An Excel Student!

I am using Excel 2013.​

 

[SpillerBD]

Nee to drop another "Sales Amount" so you can show it as a "% of Previous" Period field.