Applying functions on non qualifier crosstable fields

Aditya_Chitale — Thu, 10 Jun 2021 19:39:26 GMT

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

topic Applying functions on non qualifier crosstable fields in App Development

Applying functions on non qualifier crosstable fields