Skip to Content
0
Jan 28, 2011 at 09:37 PM

Help with Query Design - No. of Dealers in Revenue Buckets

21 Views

We are trying to develop a query that presents the Number of Dealers in Revenue Buckets by year

Current Year | # Dealers > 1 Mil | # Dealers > 5 Mil | # Dealers > 10 Mil
Last Year    | # Dealers > 1 Mil | # Dealers > 5 Mil | # Dealers > 10 Mil
2 Years ago  | # Dealers > 1 Mil | # Dealers > 5 Mil | # Dealers > 10 Mil

I'm imagining this could be done with RKF and Cell Reporting, but not sure this is the best approach yet.

What would the best approach be for a report of this type.