My best advice is to mock up some data and post a packaged workbook. But this might work for you:
Or possibly this:
It all depends on a lot of different factors. Hence the need for a packaged workbook.
Hi Shawn and anyone else who may be able to help,
I tried the count idea, but it was coming back with odd values that did not match the number of instances on an application date. The LOOKUP(COUNT([Client Name]),0)>1LOOKUP(COUNT([Client Name]),0)>1 showed true on some and false on others, but there was no pattern when using the application date. The name or id number will not change, it is the application date that indicates that they came back after being closed out.
Here is a packaged workbook with fake data. There are some with a single application date and other with 2 or more. I want to show only those that have multiple application dates.
Any help would be greatly appreciated,
Vendor Dashboard Train.twbx 49.1 KB
Having some trouble connecting to your workbook. It appears that this is connected to your server.....so you might want to remove this.
Anyway, have you tried just counting the application date instead? Since your Participant Name is in the Viz Level of Detail, you can just reference the application date to only show you those members who have multiple dates.
IF COUNTD([Application Date]) > 1 THEN 1 END
I neglected to respond to this. I did find my answer using the LOD. Thank you.