set analysis

[#1]

how to be very strong in set analysis, how to go for it to be expert in this

[renjithpl]

Hi,

selected year/max year sales-

Sum({<YEAR = {"$(=max(YEAR))"}>}Sales)

one year minus from selected year/max year

Sum({<YEAR = {"$(=max(YEAR)-1)"}>}Sales)

customer sales

aggr (Sum({<YEAR = {"$(=max(YEAR))"}>}Sales), Customer)

[#3]

Beautiful Renjith... Hats off to you... thanks for simplifying the concept.... its so nice compare to the pdf....