I have a report that combines parent and child rows in a single table. In the summary row I added the count of each row's PK (autoincrement integer), but I'd like the parent PK column to count only unique values.
Parent Child 10 21 10 22 11 23 12 24 --------------- 3 4
Is this possible?
Of course this doesn't belong to the Installation topic, but I don't see how to move it.