Attached is the query schema for a report. Pend Details and Pipeline Details are linked to Report query1
Cardinality 1..n
Operator =
Cardinality 1.1
When I add a field called pend_desc my detail including totals doubles. This is because one record can have multiple pend_decr associated with it. When I added pend_desc I changed the properties as follows:
Aggregate: NONE
Rollup: Minimum
Detail: No
How can I capture only the first instance of the field so I can avoid the duplicates.
you can try something like maximum(pend_decr for pen_id).