I'm struggling to create a SELECT STATEMENT that will return YTD values and the % of change per year.
Basically I have a huge Violation table - 'FactParkingViolation' (that holds every Parking Violation for the last 30 years).
I want it to return
The Amount (Count) of the number of Violation per Year between 20015 – 2017 and the % of change
So lets say the fields will be: Count(Year(IssueDate)), Y-2015, Y-2016, Y-2017, %OfChange
Any help will be much appreciated (: