Stacked bar chart question

[#1]

Hi

So I have 1 dimension and 6 expressions...i need a stacked chart so that expr1,exp 2,exp 3 show up in 1 stacked bar and exp 4,exp 5 ,exp6 come in the adjacent stacked bar chart.. is this possible

|

|           |exp1|         |exp4|

|           --------          --------

|           |exp2|         |exp5|

|           --------          --------

|           |exp3|          |exp6|

----------------------------------------------------------

[ecolomer · Accepted solution]

Yes, most simple are to have another variable "Group· with 2 values possibles A y B

In the graphic you write the expressions:

exp1 = if(Group='A', exp1, Null())

exp2 = if(Group='A', exp2, Null())

exp3 = if(Group='A', exp3, Null())

exp4 = if(Group='B', exp4, Null())

exp5 = if(Group='B', exp5, Null())

exp6 = if(Group='B', exp6, Null())

and put Group in a dimension.

The bar are appiled

[#3]

Thanks got it working