Count Function based on Condition in webs 3.1

Hi Folks,

I have below requirements need to calculate and then find the MTD.

Sales Old Sales Difference 20 400 400-20 100 200 200-100

Actual Requirement

YTD Sales YTD Old Sales Difference 20 400 400-20 100 200 200-100

In report I have type name and typeid fields

Condition for Sales: Select count(t1.type_name),t2.typeid from table_name1, tables_name2 where t1.type_name='ABC' and t2.typeid='A'

Old Sales: Condition

Condition for Sales: Select count(t1.type_name),t2.typeid from table_name1, tables_name2 where t1.type_name='ABC' and t2.typeid NOT IN 'A','X'

Please suggest me how to achieve this in webi. I want to count based on mention conditions and then calcualte YTD .

Looking forward your suggestions.