If I add Quantity to the equation, the data looks like this :

SKU# Description ...

nigel.c.west (7/1/2008)

---

Sorry, didn't think about the use of Previous along side SUM, I'll have a bit of a re-think.

If I understand it correctly you have something like this

Desc WK...

Nigel,

I'm getting this error when using your code:

[rsAggregateofAggregate] The Value expression for the textbox 'textbox73' contains an aggregate function (or RunningValue or RowNumber functions) in the argument to another aggregate...

Thank you for your help, I'm 90% there.

I'm having some formatting issue when I add the second table. I'm getting double departments and % different, which is 1 for...

Here is what the output looks like:

Dept Date A Date B New Colunm

A ...

I understand your post by adding the new column, but in a matrix there is only 1 coulumn that produces the 2 values. How do I do A-B when...

My data looks like this:

Date ...

Thanks for the help, that is exactally what I was looking for.

seajoker

Thanks for the help, it works as I need it to.

Thanks, that helps with the top scrolling, but can you freeze left to right? I want the 1st 3 colunms on the report not to scroll.

I added another table inorder to get the remaining plants summed. I'm getting double amounts for the RetailInstock and RetailinTransit.

select

DCLog.reportrundate as Day1

,DC.MaterialNumber

,DC.MaterialDescription

,DC.MaterialGroup

,max(Case

When DC.plant = 'DC15' then DC.unrestrictedstock

end)...

Thanks, that work beautifully!

Thank you for your help, it works like I wanted it to for my grouping.

How can I take that week ie 44,45 and change it to display a weekending date,...

I looking for the somewhat of the same results. I have a colunm that is nvarchar(18). It has a list of SKUs. Some SKUs are like SUPA123...