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