...

I will try your link.

Before I received it I found that row lost was the first one. It was due to the header being lost in process of moving from...

I am going to change my query, that's how frustrated I am. I have begun, and am testing.

That's the defacto report. Do you mean something SSRS-y when you say 'sub_report'?

I'm able to create the above matrix, minus the % rows and it's the %...

I vote for Itzhik. He also provides brain exercises at the end of the book.

thank you serg for looking over my post. OK, will take a look.

pietlinden,

Aha, Itzik Ben-Gan calls this 'sliding' and 'cumulative'

Thanks for looking that up. Your query is for 'sliding aggregate'. I turned to pg 453 and copied the...

I had similar experience with simple talk.

I tried as follows but at the very least, do not know how to group by username , etc.

SELECT username

...

took this query from stackoverflow and substituted my values. But, there's no concept of 3 month rolling average.

;WITH cte (rn, username, move_in_date, Cnt_Lead_id) AS (

SELECT...

Hi pietlinden, for one username it should look like this.

For example April's rolling average is 9+13+3/3. May's is 7+9+13/3, June's is 12+7+9/3

username---move_in_date-----------cnt_lead_id------Rolling 3 month Avg

DebiV--------2014-02-01 00:00:00------------3----------NULL

DebiV--------2014-03-01 00:00:00------------13---------NULL

DebiV--------2014-04-01 00:00:00------------9----------8

DebiV--------2014-05-01...

pietlinden,

modified and attached the rdl you sent me, having added a date column and a matrix to the right of your table.

row: referral type

columns: date

details: count of personID...

ok, now the trouble is that I don't know how to tell the expression that I need the count(lead_id) from the unfiltered set to pivot by month......

I will go to...

ok, I still think I shouldn't have to use a variable since I can reference the dataset in my expression box like so.

=Switch(Fields!row_description.Value = "Follow-Up Score", AVG(Fields!score.Value),

...

OK. Looks like I need a second dataset (unfiltered). Does it matter whether I create variable? I think not and will try that and report back.

checking it out. Thanks a lot.