Comparison actual Year

[pgalvezt]

Hello,

Im trying to compare Actual year vs Last Year by (Day-Month) , means Date(Date,'MM-DD), in pivot chart. Obviously, with month dimension there´s no problem with that because the two are showing up in the same cell, but I would like to show (Day-Month) in the same cell) , Actually my output is different cell, Because are two different years.

My Expression Are :

Current Year:

If(FieldA = '1', Num(Sum(FieldB)/Divisor,'#.##0'),

If(FieldA = '2', Num((Sum(FieldC))/Divisor,'#.##0')))

Last Year:

Sum({<Año={$(xAñoAnt)},Fecha,FechaAA,FechaDiaMes>}if(FieldA = '1', Num(FieldB,'#.##0'),

Num(FieldC,'#.##0')))

Thanks!

[pgalvezt]

Any Help?

Thank you!

[vamsee]

Can you share a sample output you desire and one which you are getting?

[pgalvezt]

Hello,

Im getting this : (Photo).

The output What I looking for is both years in the same column.

              Real      AA

01-01  741.609   298.487

Thanks!

[pgalvezt]

Found my own solution doing mapping to last year and renamed the field as Actual year. Now I can see Day-Month correctly in my dimenssion.