Case statement in script

[Rajitha1]

Hi,

I did the inline i.e.

Slice_By:
Load * Inline [
Slice_By,Slice_by_order
Product,0
Territory,1
Channel,2
];

and i have another table i.e.

from that when slice_by is product  then sales column ,

                                 slice_by is territory then region  column

                                 slice_by is channel then channel1 column i want

can any one help me regarding this in script level.

[PrashantSangle]

Can you provide more information of it. 

Sample data with expected output will help us for exact reply.

[Ahidhar]

not sure it can be done at script level

try this in "Show Column If " in Chart-

For Sales-

If(isnull(GetFieldSelections(Slice_By)),1,
if(substringCount(concat('|'&Slice_By&'|',','),'|Product|')>0,1,0))