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...

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...

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...

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

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...