I have a report that displays 3 columns (at the momnent);
* NAME - the name of the customer
* CAPTION_ID - the unique number for the name
* LISTING_ID - the unique number for each record belonging to the
NAME/CAPTION_ID.
Each NAME/CAPTION_ID can have several LISTING_ID's.
I have a break on NAME, and a Count on the LISTING_ID column, so I get the
number of LISTING_ID's per NAME.
I only want to see records where the Count (of LISTING_ID's) = 1.
I have tried 'defining a variable' and formatting filters but I can't do it
on a measure (get an error message relating to aggregates).
Any ideas?
Merry Christmas.
* NAME - the name of the customer
* CAPTION_ID - the unique number for the name
* LISTING_ID - the unique number for each record belonging to the
NAME/CAPTION_ID.
Each NAME/CAPTION_ID can have several LISTING_ID's.
I have a break on NAME, and a Count on the LISTING_ID column, so I get the
number of LISTING_ID's per NAME.
I only want to see records where the Count (of LISTING_ID's) = 1.
I have tried 'defining a variable' and formatting filters but I can't do it
on a measure (get an error message relating to aggregates).
Any ideas?
Merry Christmas.