Search results for query: *

Hi Everyone... Hopefully you all can make me look like a genius yet again. At a high level, here is what I need to do. THis data pertains to a retailer and I'm looking a Store and Item combinations where an item has not sold and counting the number of occurances. I am also doing the same for...

Eupher, That's exactly the kind of thing I was looking for... thanks!

Hi All, I need to see running totals in the output of a query. Something like this: Item # Week Gross Ship Qty Rolling Gross Ship Qty 100 200401 100 100 100 200402 50 150 100 200403 100 250 101 200401 75...

Mohawk, I think what you want to do is easily handled with some nested formulas, however, I'm not exactly sure what you want. Do you want the average of the numbers in columnB where ColumnA has a certain value or do want to take the average of all the values in columnB if a certain value exists...

You guys rock. THree people in the office, myself included spent hours trying to figure this one out. I feel silly after seeing your solutions. Cheers! Steve

Hi Everyone OK, I want to do a count of numbers in a column that meet a certain criteria. The criteria needs to be an inequality. (for instance count the number of values in the column whose value is greater than or equal to 25.) The threshold value of the inequality needs to be based on a...

OK, so if Excel 2003 is not a fix, do you think that a macro needs to be recorded for each Pivot chart, or could I write a fairly genaric Macro that would capture the charts existing format before the update and then reapply the formatting after the update? Any code samples would be greatly...

Hi, There is a known problem with pivot charts in excel 2000 where if you update data in the chart you loose all of the charts formatting. Microsoft recommends that you record a macro when applying the formatting which I suppose is an OK workaround if you are comfortable with Macros. I've...

I have a macro that I wrote in VBA that is pretty useful to a lot of people in my office. Is there a way to compile and share macros? Or I guess more to the point, what is the best way to share a macro that needs to exist in a persons Personal.xls? Thanks for your help! Cheers! Steve

Cool! I do have a question about the original partition, You said point it to a view that is a "Where 1=2" so I'm assuming that really what I want it to do is point it to an empty set of data. Now I'm partitioning on a diminsion of products that are assigned categories (the highest...

OK, so If I'm understanding you, I should create another cube that contains my distinct count as it's only measure... same diminsions, partitions etc... then join the two in a virtual cube. Does this put me in a situation where I know have two process two cubes of the same size and have...

Thanks Paul, Well, heck, I bet a partiton would do the trick... I only have 3 dimensions and luckily, one of them is not a changing diminsion... sounds like I have an easy choice for a data slice... Thanks a bunch Paul, I think you just handed me the solution! And yes, by the way I do have a...

Hi, The books Paul suggests are great! I would also add for the person who is new to MDX a book called "Fast Track to MDX" by Mark Whitehorn and Robert Zare. It's a bit lighter than than Spoffords book but I still think lays a foundation to MDX. Cheers! Steve

Hi, I am in the process of building some cubes using Analysis Services that utilize a star schema in an Oracle database. A problem I've encountered occurs when I try to process the cube. Apparently the SQL that is passed to Oracle contains an Order by clause, when Oracle tries to do the sort...

Thanks Carluk, I suspected something like that, but I couldn't find anything in the online documentation...