Skip to Content
0
Former Member
Dec 03, 2008 at 08:43 AM

Creating a query from a DSO to group into categories

24 Views

I have a DSO with data like this:

-


Transaction No / Customer

-


1 / 1

2 / 1

3 / 1

4 / 2

5 / 2

6 / 3

-


(i.e. a list of transactions with a customer ID assigned)

I want to create a query that looks like this:

-


Group / Customer Count

-


Two or less transactions / 2

Three or more transactions / 1

-


(i.e. two buckets, one count of how many customers have 2 or less transactions, one count of how many have three or more transactions)

Can someone give me an idea of how this could be performed? Can I do it with just one query, or do I need to load the data from the DSO into a new DSO with data agregated for customers somehow?

Any suggestions would be greatly appreciated.