thanks Lynn. this solved my issue and I did not make a change to the function

we would actually want to have multiple rows for this and not 1 row. Maybe a Union to load both the product and employee information into 1 column.

Below is the query used to generate these results.

SELECT

p.proj_no,

p.proj_status,

p.proj_bill_with_parent,

p.proj_desc,

pbt.emp_no + ' ' + rtrim(e.emp_first_name) + ' ' + e.emp_last_name as 'Emp#/Description',

pm.prod_no + ' ' + prod.product_desc as 'Prod#/Description'

FROM dbo.project...

still running into issues here. So if I leave the MAX function infront of my Case statement which contains the sum function for the values I need to total...

Not sure I am following what you are asking. My current output would look something like this.

Country_code Local_client_code Local_client_name 2015Rev...

the temp table was the route I took to get the results. Thanks everyone for you help.

thanks for the syntax, but when I run this in our environment, I still have the sales amount repeated for all the months where there is revenue.

that will work for some of the situations, but not always as there could be situations where there are no revenue reported in the month of the sale

the attached file has 2 tabs. The first tab is the current result set. The 2nd tab is what we are trying to get to. You will...

Also i need to clarify that the percent calculation needs to multiple against the sum of the count of employees by benefit. So for example Benid 1 may have...

I believe that will get me the correct answer now I just need to get the full percentage so I should just multiple by 100 correct?

This seems fairly complex. Couldnt this be completed by a Union query?

installing the SP1 solved my issue. Thanks:-D

No it has never worked. This is a new install of the program on my machine

This is SQL 2008 R2.