sending email for email addresses that fall below and above min and max?

I now see how to use the formula so that the YoY variance is calculated in one cell. No need to bother with the hidden tables.

It is so lucky...

how did you handle that part?

no, the answer is as follows:

instead of trying to add a second filter to the Year parent group, build the constraining expression into in the column:

=sum(iif(Fields!MonNo.Value < datepart(dateinterval.Month, today),...

David, that's sublime. Key point I took from you was

My answer, FWIW, would be to remove the year filter from the dataset and add it to the column...

Otherwise, Jack probably is on to something with the LOOKUP function and I haven't looked into that enough.

I do appreciate the help and should take ownership of not posting...

I disagree. This is a calculation and not a query optimization issue. A pure division so I do not want to tax SQL Server for that.

And exactly,...

but it's not the solution to this problem! I looked at the RDL Jack left and it involves creating another column that I can't hide or use.?

What I'm going...

yes, you and pietlinden are the only ones. And you are trying to help me but are under and over reaching each time. I need one specific thing...not...

Yeah, I'm learning SSRS. My boss knows that.

I'm asking for help with one small part of a report and not for advise on why I am bringing in...

ok, while you were responding I was coming up with the most thorough summation of what I was after with step by step instructions on how to use my DDL...

Jack, Yes I need completed months of the current year compare with same months last year. My actual query is sizable and used to feed multiple tables and charts...

Did you get help you needed? After joining the tables on id you can filter WHERE totalcount is > max and < min..ofcourse in sql it's easy. I don't have...

Thanks Jack, I'll take a look at this (just got it). I really appreciate it

btw, earlier I said

subtract last years count from this year's count to...

But, since I am not comparing the difference between rows in a sql result set LAG() is not what I'm looking for.

LAG() "Accesses data from a previous...