on 01-28-2010 7:06 PM
Hi,
I need to create a graph. On Category Axis ( X= axis) I need to show values of 5 keyfigures from a BW query. Y axis will be Values in thousand.
Currently no issues with Y-axis. But I am not able to figure out how I can have multiple category axis on X axis.
Basically what I need is a way of creating 1 category which has 5 KFs.
thanks,
Murtuza.
Hi
Not very much clear with your requirement, i will take one example -
On category axis you can show some infoobject like 'Plant Name' - so various plants will come on x-axis (Horizontally)
In Data Series you can take key figures like 'opening,closing,issue, reciept stock' - so for each plant you will get these many columns (This will take the value in thousands as you want.)
Are you looking for anything different?
Regards
Sandeep
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you all for helping.
Below is how I resolved :-
I created a structure of table (Key Figures) in Column of query designer and then use that structure in VC to output table.
There I had used formula for each KeyFigures using IF ...something like this:-
NVAL(IF(@Key_Figures=="Prior Sales",0,IF(@Key_Figures=="Price",NVAL(IF(#ID[ACA257]@Price_Impact_value>=0,#ID[ACA257]@Prior_Sales_Value,#ID[ACA257]@Prior_Sales_Value+#ID[ACA257]@Price_Impact_value)),IF(@Key_Figures=="FX",#ID[ACA257]@GAP_3,IF(@Key_Figures=="Volume",#ID[ACA257]@GAP_4,IF(@Key_Figures=="Lost Mix",#ID[ACA257]@GAP_5_6,IF(@Key_Figures=="Gain Mix",#ID[ACA257]@GAP_5_6,IF(@Key_Figures=="Current Sales",0,123))))))))
This way I got the output table as required.
Thanks,
Murtuza.
Any thoughts or suggestion ? I'm still not able to figure this out
Thanks,
Murtuza
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.