Add column with calculated values

[#1]

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

[maxgro]

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

[#3]

Thanks ...it worked

[Chanty4u · Accepted solution]

Hi,

If you got the solution please close the thread.

[#5]

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.