Split of Dimension in Chart

[#1]

Hi All,

I want to design a bar chart , in which I want to split the whole dimension into only two types,

for example if "field1" is my dimension which has following values

field1

A

B

C

D

So, In bar chart I want only two bar's i.e., one should be for A and other should be for rest of all (only one bar for B,C,D instead of separate bar's for each)

Thanks in Advance

[pokassov]

Hello!

Use this for dimension (add calculated dimension):

=if(field1='A','A','Other')

and write in lable field1