Grouping some field values - Chart

[sayadutt]

Hi Team,

I am loading data from a sharepoint list, and the columns looks like this:

[Practice Area] , [Project Name]

11,     aa

22,     bb

33,     cc

44,     dd

Now my requirement is to merge [Practice Area] into one, if it belongs to 11 & 22

So my table should look like below:

[Practice Area] , [Project Name]

XX,     aa

XX,     bb

33,     cc

44,     dd

11 & 22 are now called as XX.

I don't want to rename this at Edit Script level, as other charts should continue showing them as 11 & 22.

Requirement is only for 1 chart (and merge should be done at individual chart level).

Please suggest.

Thanks

[alexandros17]

It is not a grouping but a renaming so I can suggest an if condition in your expression or dimension

[sayadutt]

Can you please give me a sample expression.

Thanks

[alexandros17 · Accepted solution]

in your dimension:

If([Practice Area]='11' or [Practice Area]='22', 'XX', [Practice Area])