Recent content by dinzana

Perfect! This works swimmingly well!!!!!

We are using SQL Server 2012, thanks, I will take a look at this

Ah yes, I see what you mean, and sorry for that. I guess I should say I'd like to have a null when the last 5 values do not match.

Hello, I am trying to check the last 5 values of a column for each employee and if they match then i want to show that value, if they don't match, i want to show the most recent value. thanks in advance! D

Thanks to you both for great solutions and speedy fast, thanks again!!! D

Hello there and thank you in advance. I am trying to populate a column (week_number) in my employee table. I need to insert a 1 at the first entry_date and then increment by 1 for every entry_date after, in sequence for EACH employee. The issue is, each employee can have a different entry_date...

Perfect! Thanks so much!!

i need to find out the difference between sequential week numbers and store the value on the current weeks row. How can i do this is a view. I have id, shipped and week number columns as shown here, I need to get the 'desired value' column to use as a denominator. Any ideas? Great thanks in...

Is there a way to transpose data in Excel as in the example below? the id column i would like to repeat down the rows and the corresponding rec_ids listed out instead of the comma separated values. data as it stands in Excel here is what I want in Excel thanks, D

I have two data sets in a report document. R1) Date attribute with a metric value of sysdate()-1 which shows up as 20120626 for today R2) Date attribute with a metric value of maxExecutionDate which shows up as 20120625 for today What i am trying to do is create some conditional format to...

Is is possible to create a report to show the top 5 customers in sales individually and the remaining customers grouped into 'Other' or 'everyone else'? Point me in the right direction Thanks, d

Take a look at the following thread in the MSTR Knowledge Base, I think it may give you the information you need. TN5200-7X0-0155 Hope this helps, dinzana

Thanks Skip, it worked like a charm! You're a Star! dinzana

Hello All, I am trying to format a cell to be a certain color and have a double line border at the top of the cell if the value of another cell is ='Total'. I have tried conditional formatting but there are only single line borders. Here is the code that is generated when I record a macro to...

Hello All, I am trying to format a cell to be a certain color and have a double line border at the top of the cell if the value of another cell is ='Total'. I have tried conditional formatting but there are only single line borders.. thanks so much in advance. dinzana