on 09-26-2013 3:49 AM
Hi,
Need your help guys about line chart.
I have this sample data.
Customer | Demand month1 | Demand month2 | Demand month3 |
---|---|---|---|
Cust1 | 2000 | 200 | 4000 |
Cust2 | 3000 | 1000 | 4000 |
Cust3 | 5000 | 6000 | 4000 |
Total | 10000 | 7200 | 12000 |
When I tried to transform it to line chart, the measures (Demand month1, 2 and 3) was automatically assigned in value axis.
The dimension (Customer) was for category axis.
Is there a way to change to what axis they will be assigned?
Also, tried the cross table, didn't work either.
Thanks
Dan
Hardik / Arijit,
I was not able to find the solution in the link.
Don't know how to view structure of the chart. that I can't move anything inside the chart.
If I try to move, the whole chart moves.
I have tried these also:
1. right clicking the chart
2. viewing the report in design mode (Structure Only)
3. using the document structure and filters on the left side of the window.
Kindly help.
Btw, I'm using ver4.0
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
What Satish said is right. there would not be any use of assigning dimension to value axis. because Consider example if we see City,Region on both on same axis and sales on other axis. then how do you analysis od data.?
Apart form this is there any new way requirement of representation then please attach.
Best Ragards,
Atm
First graph is what I always get from BI.
Second graph is what I want to produce.
As you can see in first graph, the lines is based on measures (Month1 - Month5).
Second graph has one line for each customer.
Figures was created randomly so it will not be matched.
I just want to show what I want to come up.
Thanks as usual,
Dan
Hi Sathish,
My problem is our universe design has no month.
Meaning, each month is assigned in one measure already.
eg.
January demand will be placed in Month1 measure
February demand is Month2 measure and so on.
Doing what you said, graph will show dots only.
Is there a way to word around this limitation? Or do you suggest to redesign our universe?
Thanks,
Dan
Hi,
In addition to Gill yes you can assign data to line chart. But only measure will assign to value axis and dimesnion will assign to category axis.
Best Ragards,
Atm
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Danilo,
Right mouse click on your chart and take the option for Assign Data. You get to choose then what dimensions and value fields go where.
With regards
Gill
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Dannilo,
You can move measures from one axis to another using "View Structure". I would suggest to go through following Quick Tutorial developed by SAP, as it will explain all the features for charts which could be very helpful:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
switch to structure view of the chart and you can reposition the objects to change axis.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
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.