Year Comparison in Pivot table

[Anonymous]

Hi all,

I would like to create a pivot table with comparing the sales amount by years in month.

How to set in set analysis??

BEst REgards,

Louis

[ChennaiahNallani]

try like below

Expression for Current Year:- =SUM({$<DateField = {'>=$(=YearStart(Today()))<=$(=MonthEnd(Today()))'}>}sales)

Expression for Previous Year:- =SUM({$<DateField = {'>=$(=AddMonths(YearStart(Today()),-12))<=$(=AddMonths(MonthEnd (Today()),-12))'}>}sales)

• compare current year previous year