USe set analysis to restrict data not using Sum

[james]

All, i am trying to get a set analysis to work so i can have a column restricted for a group, lets call it NOrth America.

I am trying to basically state if(data ="200, 300 , 400",'North America')

Basically I am tryng to forc in a grouping for 200,300 or 400 to be called North America

Any ideas? I cannot seemt o get set analysis to work outside of sums

[stephencredmond]

Hi,

If I have to use a set on a field that is not part of a Sum/Count (e.g. a single value), I will generally use something like Max or MaxString so as to give me the option to include the set.

I have to ask though. Wouldn't it be easier, and more efficient for the calculation of your charts, to create these values in the script using a mapping?

Regards,

Stephen