ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
FISCAL_YEAR
ACCOUNTING_PERIOD
FISCAL_DATE
ACCT_LEVEL_1
ACCT_LEVEL_2ACCT_LEVEL_3SCENARIO_TYPE (I only pull Budget rows from this column, not Actual rows, for use in the viz)AMOUNT (dummy)
Revenue Type
Acct level 3 order
2
202617/1/25 0:00
Total Revenue
Passenger RevenuePassenger RevenueBudget100Bus1
3
202517/1/24 0:00
Total Revenue
Passenger RevenuePassenger RevenueBudget200Bus1
4
202417/1/23 0:00
Total Revenue
Passenger RevenuePassenger RevenueBudget300Bus1
5
202317/1/22 0:00
Total Revenue
Passenger RevenuePassenger RevenueBudget300Bus1
6
202217/1/21 0:00
Total Revenue
Passenger RevenuePassenger RevenueBudget200Bus1
7
202617/1/25 0:00
Total Revenue
Passenger RevenuePassenger RevenueActual100Bus1
8
202517/1/24 0:00
Total Revenue
Passenger RevenuePassenger RevenueActual200Bus1
9
202417/1/23 0:00
Total Revenue
Passenger RevenuePassenger RevenueActual300Bus1
10
202317/1/22 0:00
Total Revenue
Passenger RevenuePassenger RevenueActual300Bus1
11
202217/1/21 0:00
Total Revenue
Passenger RevenuePassenger RevenueActual200Bus1
12
202617/1/25 0:00
Total Revenue
Passenger RevenuePassenger RevenueBudget100Rail1
13
202517/1/24 0:00
Total Revenue
Passenger RevenuePassenger RevenueBudget100Rail1
14
202417/1/23 0:00
Total Revenue
Passenger RevenuePassenger RevenueBudget200Rail1
15
202317/1/22 0:00
Total Revenue
Passenger RevenuePassenger RevenueBudget300Rail1
16
202217/1/21 0:00
Total Revenue
Passenger RevenuePassenger RevenueBudget300Rail1
17
202617/1/25 0:00
Total Revenue
Passenger RevenuePassenger RevenueActual200Rail1
18
202517/1/24 0:00
Total Revenue
Passenger RevenuePassenger RevenueActual100Rail1
19
202417/1/23 0:00
Total Revenue
Passenger RevenuePassenger RevenueActual200Rail1
20
202317/1/22 0:00
Total Revenue
Passenger RevenuePassenger RevenueActual300Rail1
21
202217/1/21 0:00
Total Revenue
Passenger RevenuePassenger RevenueActual300Rail1
22
202617/1/25 0:00
Total Revenue
Passenger RevenuePassenger RevenueBudget200Access1
23
202517/1/24 0:00
Total Revenue
Passenger RevenuePassenger RevenueBudget100Access1
24
202417/1/23 0:00
Total Revenue
Passenger RevenuePassenger RevenueBudget100Access1
25
202317/1/22 0:00
Total Revenue
Passenger RevenuePassenger RevenueBudget200Access1
26
202217/1/21 0:00
Total Revenue
Passenger RevenuePassenger RevenueBudget300Access1
27
202617/1/25 0:00
Total Revenue
Passenger RevenuePassenger RevenueActual300Access1
28
202517/1/24 0:00
Total Revenue
Passenger RevenuePassenger RevenueActual200Access1
29
202417/1/23 0:00
Total Revenue
Passenger RevenuePassenger RevenueActual100Access1
30
202317/1/22 0:00
Total Revenue
Passenger RevenuePassenger RevenueActual200Access1
31
202217/1/21 0:00
Total Revenue
Passenger RevenuePassenger RevenueActual300Access1
32
202617/1/25 0:00
Total Revenue
Non-Passenger RevenueParking RevenueBudget300Parking2
33
202517/1/24 0:00
Total Revenue
Non-Passenger RevenueParking RevenueBudget200Parking2
34
202417/1/23 0:00
Total Revenue
Non-Passenger RevenueParking RevenueBudget100Parking2
35
202317/1/22 0:00
Total Revenue
Non-Passenger RevenueParking RevenueBudget100Parking2
36
202217/1/21 0:00
Total Revenue
Non-Passenger RevenueParking RevenueBudget200Parking2
37
202617/1/25 0:00
Total Revenue
Non-Passenger RevenueParking RevenueActual300Parking2
38
202517/1/24 0:00
Total Revenue
Non-Passenger RevenueParking RevenueActual300Parking2
39
202417/1/23 0:00
Total Revenue
Non-Passenger RevenueParking RevenueActual200Parking2
40
202317/1/22 0:00
Total Revenue
Non-Passenger RevenueParking RevenueActual100Parking2
41
202217/1/21 0:00
Total Revenue
Non-Passenger RevenueParking RevenueActual300Parking2
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100