Thanks for your previous post. I've run into another hurdle, and would
greatly appreciate any help you may be able to offer. I have revenue
data sorted by month and years for a number of distinctly labeled
stores (imagine a Center ID). I would like to find the percentage of
"gainers" (stores whose monthly revenues exceed the previous month's
revenues) out of the all the stores. I know how to determine this by
using an individual queries to sort out each store's revenue by year
and month, and then use another query to classify gainers v. decliners,
and then (Fnally!) calculate the percentages. Is there an easier way to
do this than to run around 50 queries (one for each month for 4 years)?
Re: Apple Store Revenue up over $1Billion for year ... Apple CFO Peter Oppenheimer revealed during the company's Wednesday conference call that fiscal year 2006 revenue from its chain of retail store increased more than US$1 billion over 2005. ... Apple's 165 stores brought in $963 million in revenue for the quarter that ended Sept. 30, 2006, up 41% from the same period last year. ...Profit during the quarter was $29 million, the same as the previous quarter. ... (comp.sys.mac.advocacy)
Re: Old Navy vs Gap vs BR ... > very black mark on the record of Gap,... Surprisingly, last year Old Navy... > brought in the most revenue of the three stores.... As far as revenue, I bet McDonald's makes a hell of a lot more money ... (alt.fashion)
Re: Apple Store Revenue up over $1Billion for year ... Apple CFO Peter Oppenheimer revealed during the company's Wednesday conference call that fiscal year 2006 revenue from its chain of retail store increased more than US$1 billion over 2005. ... Apple's 165 stores brought in $963 million in revenue for the quarter that ended Sept. 30, 2006, up 41% from the same period last year. ... the stores: cases, iPod accessories, etc. ... It doesn't include the hundreds of millions in profits on the computers and iPods that are sold through the retail division, which are reported as manufacturing profits. ... (comp.sys.mac.advocacy)
Re: Old Navy vs Gap vs BR ... last year Old Navy brought in the most revenue ... >of the three stores....Wal-Mart brings in the most revenue of any store by ... (alt.fashion)
Re: can I reduce the number of queries? ... Summation query grouped on Store, Month/Year in the 1st 2 queries, should ...stores. ... using an individual queries to sort out each store's revenue by year ... and month, and then use another query to classify gainers v. decliners, ... (comp.databases.ms-access)
