Stacked Chart

[jagan]

Hi,

I need to create a stacked bar chart, with no dimension and with 15 expressions.  Is there any way to display the first 5 expressions as one stacked bar, second 5 expressions as one stacked bar and remaining 5 expressions as another stacked bar.  When I tried using the Stacked option in Style tab all 15 expressions are converted into one stacked bar.  Is there any work around for this.

Regards,

Jagan.

[vincent_ardiet]

Hi Jagan,

May be you can try using two fake dimensions created with the help of valuelist.

First dim : =ValueList('A','B','C')

Second dim : =ValueList('1','2','3','4','5')

In the single expression you will have to do something like this :

if(ValueList('A','B','C')='A',if(ValueList('1','2','3','4','5'),'1',Measure1,if(ValueList('1','2','3','4','5'),'2',Measure2...

I'm not sure that 2 ValueList are possible in the same chart.

Regards,

Vincent

[jagan]

Hi Vincent,

Thanks for your valuable time and help.  This works for expressions without AGGR().  Is there any alternate when you use AGGR().

Regards,

Jagan.

[vincent_ardiet · Accepted solution]

It doesn't work if you put AGGR() in the IF expression ?

As your chart has no dimension, may be can you define 15 variables containing the result of your different expressions (their definitions must start with an = sign) and use them in your chart expressions?

Regards,

Vincent

[jagan]

Hi Vincent,

Thanks for your great help.  This works as I expected, I put all my expressions in variables and used ValueList as you said in Dimension.

Regards,

Jagan.