Pivot table AGGR, MAX function return null value

[phoenix]

I have first three columns in my data and I am trying to get to last three column in a pivot by VINTAGE_YR and TOB. I am trying to get to set analysis using AGGR, MAX functions

[sunny_talwar · Accepted solution]

May be this

1) Max(TOTAL <VINTAGE_YR, VINTAGE_MTH> TOB)

2) Max(TOTAL <VINTAGE_YR> TOB)

3) Max(TOTAL <VINTAGE_YR, TOB> VINTAGE_MTH)

[phoenix]

Thanks