Perform calculation in new crosstab from values of 2 different crosstabs???

[cognosbuddy]

Hi friends,

I have two crosstabs. In crosstab-1, I have EST. In crosstab-2, I have LTF. I would like to create a new crosstab-3 which has the following calculation EST/LTF-1 based of the previously created crosstabs.

Can you please help me how I can do this? I have attached an image for clear understanding. The picture represents exactly the contents of my crosstabs.

Thank you.

[Gyana]

Join crosstab-1 & crosstab-2 Query on Month.
Join Query only Drag the Month & use a dummy Data item 'EST/LTF'. in Calculated data item put XXX/YYY. Then use those in Crosstab-3uery