calculation over 2 crosstables

[Sipo]

How can I display a column as a percent over two crosstables?

example:
In  crosstable 1, we have a column "No. of flights" indicating the total flights in the period February 2014 (example: 1850 flights ).
In the second crosstable we have a calculated column that displays the flights in the period between February 2014 and with a delay code Xx (example: 5 flights). Now I want to display in the second crosstable the  flights "5" as a percentage.

Issue: I can not make a calculation on two crosstables. Have you perhaps a resolve?

I use the Report Studio v. 10.2.1


thank you!

[MFGF]

Are you using a dimensional or relational package? Do the two crosstabs share the same query in the report?

MF.


Sent from my iPad using Tapatalk HD

[Sipo]

good morning MFGF,

we use a dynamic (dimension and measures) package that is based on a relation database. The queries of the crosstables are different. If i put the column fom first table into the secound... i will get the same measures. [Delay in %[]

thank you

[MFGF]

good morning MFGF,

we use a dynamic (dimension and measures) package that is based on a relation database. The queries of the crosstables are different. If i put the column fom first table into the secound... i will get the same measures. [Delay in %[]

thank you

If you're using a DMR package then you have all the nice dimensional functions available to you...

What do you see if you drag the No. of Flights column from your package as a new column into the second crosstab? Do you get the same values for each year?
If so you can then simply add a query calculation as a new column that divides Delay>0Min by No. of Flights then format as percentage?

If not, can you provide more detail on why this isn't possible?

Cheers!

MF.

[Sipo]

Good morning,

I had already tried with the calculate task. If I put the No. of. flights into the secound crosstab then i get the same values (Delay>0Min == No. of flghts.)

But in the column of Delay>0Min there is also a query:

IF ([Delay departure (minutes)]>0)
THEN ([No. of flights])
ELSE (0)

Look at the rows "57", "61" and "81", these are Delay reasons. I have to disconnect the relation between the 57, 61, 81 and No. of flghts. Cause the No. of flights reference the same values like Delay>0Min.

[Percentage][/]





Thank you for your help :-D

[MFGF]

There must be something else going on here we're not seeing, otherwise the values would not be the same. Have you defined detail filters for this crosstab? Slicers?

MF.

[Sipo]

Hello,

i defined just for the first crosstab (no. of flights). It delimits the flights for one airline. Maybe i have to bring the reports together?

help me please   :-[

Thx!