please help(:

%3CLINGO-SUB%20id%3D%22lingo-sub-1938346%22%20slang%3D%22en-US%22%3Eplease%20help(%3A%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1938346%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI'm%20struggling%20to%20create%20a%20SELECT%20STATEMENT%20%26nbsp%3Bthat%20will%20return%20YTD%20values%20and%20the%20%25%20of%20change%20per%20year.%3C%2FP%3E%3CP%3EBasically%20I%20have%20a%20huge%20Violation%20table%20-%20'FactParkingViolation'%20(that%20holds%20every%20Parking%20Violation%20for%20the%20last%2030%20years).%3C%2FP%3E%3CP%3EI%20want%20it%20to%20return%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20Amount%20(Count)%20of%20the%20number%20of%20Violation%20per%20Year%20between%2020015%20%E2%80%93%202017%20and%20the%20%25%20of%20change%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20lets%20say%20the%20fields%20will%20be%3A%20Count(Year(IssueDate))%2C%20Y-2015%2C%20Y-2016%2C%20Y-2017%2C%20%25OfChange%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20will%20be%20much%20appreciated%20(%3A%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22factparkingviolation.jpg%22%20style%3D%22width%3A%20737px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F236477i39AD25D9AE590553%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22factparkingviolation.jpg%22%20alt%3D%22factparkingviolation.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1938346%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAnalysis%20Services%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAnalytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EBig%20Data%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1959012%22%20slang%3D%22en-US%22%3ERe%3A%20please%20help(%3A%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1959012%22%20slang%3D%22en-US%22%3EAre%20you%20needing%20the%20formulas%20fixed%20on%20excel%3F%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

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 (:

 

factparkingviolation.jpg

1 Reply
Are you needing the formulas fixed on excel?