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.
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