Applying functions on non qualifier crosstable fields

[Aditya_Chitale]

Hi All,

Is there any way to apply 'if() condition' on non qualifier fields in a crosstable ? Below is the table in which I used crosstable function. if not possible, then is there any way to take resident of 'Target' into a new table ?

I tried taking resident but I am unable to see any fields in frontend.

Target:
CrossTable(Month,Target,3)
LOAD
//'Channel_Partner' as flag,
Division,
Region,
Upper("Channel Partner") as "Channel Partner",
Jan,
Feb,
Mar,
Apr,
May,
Jun,
Jul,
Aug,
Sep,
Oct,
Nov,
Dec

Regards,

Aditya