Window functions work wonders I heard and I am very keen on learning how to use this stuff. Any good literature on the web you would recommend?

Thanks for your...

Thanks for your reply but your query isn't giving me the correct result! But this one does...

with MyData as

(

select Stack

, RefID

, Name

, ROW_NUMBER() over (Partition by RefID order by Stack)...

I think that will work if set this as a sub query and inner join with the dataset on TheDate.

Thank you.

This does not work. The calculation is still being applied on all rows for 2014.

Thank you but it is not what I want. You have projected all the 2014 values based on the 2013 values. I only want the 2014 projection to start from...

I was hoping to calculate that on the 2013 figures and maybe add a 5% increase for this year,is that possible? the forecast is seasonal and the last quarter retailers...

Chris,

Your date function is very cleverly written. Is there a way to get a bigger dataset out of this function? I want a date to start from 01/01/2012 till 31/01/2015.

What...

Hi Chris,

My apologies, I was confused when I didn't see data for Tuesday week 4 2014 and then there was data for Wednesday week 4 2014. The reason for this...

Yep, I changed it to WHERE MONTH(c.TheDate) IN (10,11,12). Is that causing the issue?

Sorry, it's a lot of data. I hope that's the correct way to post this here.

SELECT * FROM

(

VALUES

('2012-10-18','DM4',1858),

('2012-10-18','DM2',309 ),

('2012-10-18','DM3',750 ),

('2012-11-12','DM2',717 ),

('2012-11-12','DM3',1820...

Hi Chris,

After testing I have noticed that this query isn't working as expected. I'm getting 0 parcel count 2014 for Tuesday weekNo 4 in October, then there are parcel count...

Chris,

This seems to be doing the trick :). I will carry on testing and will either mark this as answered or come back with more questions.

Thank you very much.

Hi Chris,

Please find attached an excel sheet with the way I want the report to look like. I think removing 'Stack' will make it simpler, but it would be good...

Hi Cris,

As a title will be best please.

Also, please note that I need to report on data October,November and December 2012,2013 and 2014. Now, I will get

4 Mondays...

Chris,

Absolutely. A Month (and probably a year) on the report will be good. The dataset will contain October, November, December data for 2012,2013 and 2014 so it will probably be...