Summation query grouped on Store, Month/Year in the 1st 2 queries, should
reduce the count to 3.
"jonm4102" <sutasa@gmail.comwrote in message
news:1153163405.325682.153580@i42g2000cwa.googlegr oups.com...
Quote:
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)?
>
Thanks.
>
Jonathan
>
|
