how to create calculated dimension based on the result of query.
I have made a pivot table in which i have categorised the results on annual basis.. ie have made cross table where the measures like Total Revenue are on vertical axis and Period year are on horizontal heading. Now i want to compare the total revenue in Period-Year 2009 and 2010. How can i make a third column Trend based on the data of two or more years.
