I have a database that has a list of names and the hours that these people worked. I am busy creating an invoicing checking report and need some help figuring out how to do this one thing in particular.
I want my dimension, which is "Name" to list only names and sum hours for where I have an if clause. The if clause would work like this. If the person has a particular cost code appearing more than once for a particular week, list his name and his hours for where there is a 'duplicate' essentially. How would I do this?
Thanks Iiron, we are really close From the sample data I gave you it works PERFECTLY. I'm not sure why in my 'real world' data it is not doing exactly the same. Basically what is happening is that it indicates in the aggr column if the condition is true with a 1 (which is great). For all other fields it is showing a '-' which I know to be Null???? What would I need to change to get it to not show results for items that dont fit the condition i.e. the '-'?