I want to take some data in a cross over table and put some flags on it. The flags work fine when not crossover but fail when I convert to crossover. Is there any ay to make this work please. Data is coming form a spread sheet that is fed out of Sage so I cant alter it easily.
LOAD Client, Code, Jan, Feb, Mar, Apr, May, June, if(WildMatch([Code],'*1001*') andWildMatch([Code],'*Revenue*'),1,0) asMSKTriageFLag
CrossTable(Date, Data, 2) LOADClient, Code, Jan, Feb, Mar, Apr, May, June,