Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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.
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
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.