dynamic pivot on months

**masond3** · 08-11-2012, 12:35 PM

Aim –

to get the last three months sales figures, from the date the report has been run, and put the the figures in separate columns associated with months.then provide a flag to give me indiciation if the sales amount has decreased by 10% within those 3months

The table which i am using is

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

[hst_merchnum] =
[hst_date_processed] =date of transactions, date is listed as 20120101 (y,m,d)
hst_sales_amt] = sales amount

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,
001 £1000 , £2000, £5000

eg 2) – ran report in august
hst_Merchantnum, June, july, August,
002 £1000 , £2000, £5000

**oeldere** · 08-11-2012, 12:38 PM

You get better help if you post an Excel-example of your workbook, without confidential information.

Make sure the workbook demonstrates your desired results if possible, or just highlight the cells you're trying to fix.

Use BEFORE/AFTER sheets if that helps make it clearer.