Hello,
I am trying to remove duplicate records from a report - is that possible? I am creating a report to see accounts with invoices in the last 15 days, but I just want to see the account mentioned once not 15-20 times ha. I know I can show the unique count, but I want to remove the duplicates entirely.
Thanks!
답변 2개
Hi Harrison,
You'll want to create a report on JUST accounts, without invoices. Then use a cross filter to add Accounts with Invoices. Add additional criteria to the cross filter that the invoice must be up to 15 days old.