Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Perfect ! Seems sooo simple now.
Thank You.
Brian