Aim –
To look at ‘hst_sales_amt’, for last 3months, by using the ‘hst_date_processed’ and determine, whether ‘hst_sales_amt’has decreased by 10%

I would need columns created so i can show last 3months hst_sales_amt from point of report

For eg – ran report in march

layout

hst_Merchantnum, Jan , Feb, march,

eg 2) – ran report in august
hst_Merchantnum,june, july, august


table which i am using is

SELECT TOP 1000 [hst_merchnum]
,[hst_date_processed]
,[hst_sales_amt]
FROM [FDMS].[dbo].[Fact_Financial_History]