Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Need expert advice.
My data like this:
Set 1:
ITEM Value Month
1 50 Jan
1 20 Jan
1 30 Feb
1 25 Feb
1 80 Mar
1 70 Apr
Set2:
Month Item defect
Jan 20
Feb 5
Mar 35
Apr 10
Now i want to show information as follows:
Month Item-Total Value Item-defect %
Jan 70 20 20/70*100
Feb 55 5 5/55*100
Mar 80 35 35/80*100
Apr 70 10 10/70*100
Please suggest, what the best view to show data in above format...List box or Chart..
Regards
Sandeep
load your data
Set1:
load * inline [
ITEM Value Month
1 50 Jan
1 20 Jan
1 30 Feb
1 25 Feb
1 80 Mar
1 70 Apr
] (delimiter is spaces);
Set2:
load * inline [
Month Item defect
Jan 20
Feb 5
Mar 35
Apr 10
] (delimiter is spaces);
build a straight table chart with one dimension and 3 expressions
Thanks ...it worked
Hi,
If you got the solution please close the thread.
I marked is "Answered". What do you mean by "Close".
I am new to this community, so please let me know if something else need to be done to "Close" the thread.