Skip to Content
0
Former Member
Aug 08, 2016 at 01:54 PM

Help with Group - Distinct Count

91 Views

Hello guys,

i've got a problem with a count of a group and i don't know how to solve it.

I've got a MasterTicket -> with a MasterID, but the MasterID can have more than one Subticket.

In the Details i'm always counting 1 if there is a ticket in a month, afterwards i got a Group Summary on this field which counts the tickets in a month. The problem is now, that i only want to count the MasterID's and not all the rows with the Subtickets.

I got this screenshots which describes the behavior, hope this is clear?

Does somebody know how to achieve this?

THX and BR

Rudi

Attachments

Screenshot.PNG (27.8 kB)