How to create a condition column in QV

[#1]

Good day,

I have a table as below:

I want to create this new column, considering the date in column C, with the condition that it shall consider only the date in column B as "Air" and also considering in column A for each number respectively.

A	B	C	New Column
1	Air	01/01/2012	01/01/2012
1	Ball	02/01/2012	01/01/2012
1	Car	03/01/2012	01/01/2012
2	Ball	20/01/2012	21/01/2012
2	Air	21/01/2012	21/01/2012
2	Car	22/01/2012	21/01/2012
2	Desk	23/01/2012	21/01/2012
3	Desk	01/02/2012	02/02/2012
3	Air	02/02/2012	02/02/2012

Regards, Jorge

[swuehl]

In a chart, you can try something like

=only({<B={Air}>} total<A> C)