Can I use different calculation methods in a crosstab using union queries?

[kupe@lmwindpower.com]

Hi,

I would like to make a crosstab reporting 1) Received orders, 2) Planned sales and 3) Visibility (1 divided by 2).

I have made 3 queries with the 1,2 and 3 parts above and combined them in a Union query.
A field in the query is used to set the header of the 3 parts in the crosstab.

I have no problem showing 1 and 2, but the 3) Visibility part is summarizing the data from the lower levels giving me 3, if I have received orders for all sales in June-September and is showing numbers by quarter (I would like to get 1 as result)

I have also a Sum column for 2014 which is summarizing the 4 quarters instead of calculating using the yearly sums of 1) and 2).

Can I tell Report Studio to make the calculation at the level I'm showing in the crosstab?
Can I tell Report Studio to calculate the sum-columns using the totals of 1) Received orders and 2) Planned sales?

Thanks in advance for your help.

[teresa.danna@gmail.com]

Hi Kupe,

Is it possible you could list out the basic objects for 1, 2 and 3 or maybe a simple example of what you're trying to accomplish? I'm having trouble following why 3 needs to be a query in the union, instead of just a calculation once 1 & 2 are unionized. Is it a dimensional datasource?