Example Query: comparing titles per year

What is the total amount earmarked per Title and how does it change over the years?

This query is similar to the one of question 4, though all amounts are added up and the results go back to 2016. In this case, they are added up at the level of Title, while in the previous question the level of Article was used.

Once the totals are added up, the query shows for each title the values of 2016, 2017 and 2018:

TiAlias

Title_Heading

Amount_a

Year

01

Economic and financial affairs

2208268036

2018

01

Economic and financial affairs

3361394801

2017

01

Economic and financial affairs

2533752168.82999999

2016

02

Internal market, industry, entrepreneurship and SMEs

2356185710

2018

02

Internal market, industry, entrepreneurship and SMEs

2437745834

2017

02

Internal market, industry, entrepreneurship and SMEs

2391075116.62

2016

03

Competition

109841980

2018

 

 

Categorisation

Type of document
Document
Login or create an account to comment.