Skip to content
Advertisement

Percent Growth Calculation from Single Column

I am trying to calculate the percent growth of a single column (COUNT column) as shown below:

The following here is the desired output with a Percent Growth Column taking into consideration the weekly change of the middle COUNT column:

When i did the following line of SQL, this did not give me the correct values for the percent growth! Any advice?

Advertisement

Answer

how about using a sub query:

User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement