Counting Unique values

[pixie_1]

Hi

I have a report that I group by the Group ID

There are many transactions underneath each group ID E.g.
GroupID = 1234
QF
QF
DJ
DJ
SI

Another example
Group ID: = 5678
SI
SI

What I would like to do is 2 things,

Firstly display only the transactions where there are multiple different transactions (The first example) Then do a count on the number of transactions that fall into each bucket

So a report would display only the first example, and would suppress, or not call up the second example what so ever.

Can anyone tell me if this is possible, and if so, how can I go about it?
I tried doing a distinct count but failed as on the first example it would mark them as 1,2,3 and transactions where there are only 1 unique reference such as example 2 would be 1, so trying to say, suppress when Distinct count ,= 1 wouldn't work.

Any ideas?

[DBlank]

So you want your report to look something like:

GroupID = 1234
QF (2)
DJ (2)
SI (1)

Another example
Group ID: = 5678
SI (2)

If this is what you want,
Keep your first group on the "Group ID"
Create a second group on your "transaction field" (eg "QF")
Do a Summary count (not a distinct count) at group level 2 on the "transaction field"
You can move the summary field into the group header 2 from the group footer 2 to make it appear next to your transaction counts as in the example above or you can leave it in the footer depending on how you want it to appear.
You can then suppress the detail level altogether.