I have problems creating the appropriate relationship and consequently cannot display my data as I want to.
I have the following tables with lots of data created from csv. It is very hard to alter these files as they come in ready.
table 1 Calendar table: full-Date, day, month, year, ...
table 2 Incoming Flights: full-Date, Airline-code, representative-code, ...
table 3 passengers: full-Date, Airline-code, NumberofPassengers, ...
table 4 Airlines: Airline-code, AirlineName, ...
table 5 Representatives: representative-code, FullName, ...
The Question is how and what kind of relationships and or measures I need to create in order to be able to create a pivot table with the following data:
also slicer with year and months are present to select desired period.
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Representative Full name
[/TD]
[/TR]
[TR]
[TD]Airline Name
[/TD]
[TD]Total number of passengers
[/TD]
[/TR]
</tbody>[/TABLE]
all tables have also additional info not related to this problem
full-Date = dd/mm/yyyy
the representative can change on a daily basis (can do several different airlines per day and they are not bound to any specific Airline BUT they do all flights from a specific airline on a particular day).
the Incoming flights table can have several entries per day of the same airline-code according to certain specifics.
Any help would be greatly appreciated
I have the following tables with lots of data created from csv. It is very hard to alter these files as they come in ready.
table 1 Calendar table: full-Date, day, month, year, ...
table 2 Incoming Flights: full-Date, Airline-code, representative-code, ...
table 3 passengers: full-Date, Airline-code, NumberofPassengers, ...
table 4 Airlines: Airline-code, AirlineName, ...
table 5 Representatives: representative-code, FullName, ...
The Question is how and what kind of relationships and or measures I need to create in order to be able to create a pivot table with the following data:
also slicer with year and months are present to select desired period.
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Representative Full name
[/TD]
[/TR]
[TR]
[TD]Airline Name
[/TD]
[TD]Total number of passengers
[/TD]
[/TR]
</tbody>[/TABLE]
all tables have also additional info not related to this problem
full-Date = dd/mm/yyyy
the representative can change on a daily basis (can do several different airlines per day and they are not bound to any specific Airline BUT they do all flights from a specific airline on a particular day).
the Incoming flights table can have several entries per day of the same airline-code according to certain specifics.
Any help would be greatly appreciated
