You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Highlight duplicates values in a report if not all columns are duplicated

Received Response
12
Views
1
Comments
edited Jan 26, 2018 4:11PM in Reporting & Analytics for B2C Service 1 comment

Content

I have a report with, say, 4 columns. Two lines of the data have identical values in 1 column, but not the other columns. I want those two lines to be highlighted/flagged somehow (exception?)

 

Example Data
Name Opportunity ID Amount Address
John Smith 1001 £99.99 1 High Street
Jane Jones 1002 £50.56 1 Main Street
Jane Jones 1002 £50.56 56 High Road
Peter Person 1568 £525.45 91 Low Close

In this case, the Opportunity ID for rows 2 and 3 would be highlighted red.

 

Is this possible? If so, how?

---

TIA,

Neil

Version

May 2016

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!