How to split an item?

[#1]

Good day,

I have a database in QV that are considering the item a and b together. Example, a has 30 units and b has 21 units, but my data is as below:

Header 1	Header 2
a	50
b	1
c	20
d	30

How can I create a third header with a condition to consider item a only with 30 units and item b with only 21 units? Is it possible?

Tks and rgds,

Jorge.

[jvitantonio]

load

Header1, Header2,

if(Header1 = 'a', 30,If(Header1='b', 21)) as Header3

from your table...

[CELAMBARASAN]

Hi,

     How you got the condition has a=30 and b=21?Is it always 30 and 21?Did you calculated based on some data?

Celambarasan

[#4]

Actually, i forgot to mention, item a is based 60% for a and 40% for b + b units