I guess, this work need to handle in Database level,not in the report. report works on the aggregation and details or at least some uniqueness in the rows
Its only based on my experience, I mention .
I have added 2 more rows to have clear result.
employee age division Project A 5 accounts x A 5 accounts y A 5 accounts z C 10 accounts z C 10 accounts z B 10 HR x B 10 HR y
Here I am using INCLUDE LOD, which will first aggregate at division/emp level.Attaching the workbook.
duplicate_issue_v10.3.twbx 12.7 KB