Flag Value as a duplicate in Straight Table

[Brip51]

Hi,

I am trying to create a column in a Straight Table that flags an ID as a duplicate in that table.

I can do it in a table with just the ID, but when I add other dimensions my logic does not work.  

In the screen shot below I have the tables.  Table one I can call out a duplicate Id.  Table 2 shows what happens when I add other dimensions.  

I am not sure how to get what I want.  Any help would be greatly appreciated.

Thank You,

Brian

[Nicole-Smith · Accepted solution]

Change your count calculation to:

count(total <CID> CID)

This will ignore the other dimensions that you're adding and only worry about counting the ID.

[Brip51]

Perfect ! Seems sooo simple now.

Thank You.

Brian