Excel Pivot Table Exclude one Row in Calculated Field -

in microsoft excel want have pivot table uses calculated field row. calculated row exlude current year. want 2 summary rows 1 current year , 1 without. attachment in orange shows desired result.

i know can manually make cell formula each month, automatic. thoughts?

if row variable called "year", column variable called "month", e1 1 of cells in pivot table , values variable called "score", like

=getpivotdata("score",e1,"month","jan")-getpivotdata("score",e1,"month","jan","year",year(now())) 

and repeat each month.

however need leave room under table expand avoid over-writing orange cells.

the other way can think of obvious 1 of copying whole pivot table , filtering on row labels, excluding 2015.

you can copy pivot table selecting whole table (can use ctrl shift *), right-clicking, selecting copy , pasting somewhere else.

this mini-example showing 2 methods.