using 2 measures as one measure in cognos transformer

[damzi]

Hello Cognos Gurus,
Here is the data that I am looking to model in Cognos Transformer...

ColumnDate ColumnTRS ColumnLMN RevenueX RevenueY
A Calculate*
201601 B Telltale 10 20
201603 B Fixit 10 20
201602 B Telltale 10 20
201601 B KickAss 10 20
201603 B Fixit 10 20
201602 B KickAss 10 20
201601 B Telltale 10 20
201601 B Telltale 10 20

So Column TRS has 2 categories A,B. RevenueX Allocation for A is a calculation RevenueX/count(RevenueX for ColumnDate, ColumnLMN
I have 2 queries feeding my cube - one being to calculate the RvenueX value for Category A from ColumnTRS.
So I have 2 queries populating the cube with 2 measures.
The requirement is to view the RevenueX and RevenueY as one measure RevenueXY. Here is the output expected from the cube

RevenueXY
A 80
B 160

RevenueXY
A 201601 40
201602 20
201603 20

B 201601 80
201602 40
201603 40

Also please note that Category A does not have any child categories but category B has 3 levels of categories.

Any ideas on how to work this ? I am using report studio reports to feed the cubes.

Thanks, damzi