i have some data and I am having difficulty creating a query to group the data by month year and then show current month value and the previous month value by city, example shown below
i have the below data
i need a query which will return the below ( based on current month being February)
|date||city||previous Value||Current Value|
can this be done?
thanks for any help provided