Hi,
I have a table that looks like the following:
Name | Month | Income | Sales
Mike | 07/2017 | 10000 | 500
Anna | 07/2017 | 12000 | 125
John | 07/2017 | 09000 | 90
Mike | 08/2017 | 11000 | 600
Anna | 08/2017 | 15000 | 130
John | 08/2017 | 07000 | 80
I have tousands of rows.
I want to make a query that:
- Filter the rows based on the sales number (> 100)
- Shows the monthly change in sales and in income
Name | Month | Sales | Sales Change | Income Change
Mike | 08/2017 | 10000 | 20% | 10%
Anna | 08/2017 | 15000 | 04% | 25%
Is this possible?