Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
Thanks