Grouping Values within a Dimension in Chart

[#1]

One of the dimensions in my chart contains many values. I want to show the chart with a few of those grouped together. As shown in the attached file there are two descriptions which I want to group together only for the purpose of this chart and not at script level.

Is there any quick way of doing this?

Thanks.

[#2]

The best way to do is create a new field on a table to group values like this.

Load a,

         b,

         c,

         if(a='value','grouped value',if(a='value 2','grouped value',a)) as group

form ....

i Hope to help you.

[Sokkorn]

Hi,

Maybe use <Add Calculated Diemension> can do this job. Let try =If(WildMatch(DIS_DESC,'*NORMAL DELIVERY*','*BY C-SECTION*','GroupName',DIS_DESC))

Regards,

Sokkorn