I have one excel sheet containing: First Name, Last Name, Company, List Type, Importance. Basically I wanted to see what names (based on only first and last name) were on this list twice so i created a straight table with First Name and Last name as dimensions and the expression: if(count([Last Name]&[First Name])=2,'Both','Single'). So every name that is on the list twice comes up as Both. I also have a table box containing everything from the excel doc. This seemed to work fine except once i clicked on something in the table box, the straight table doesn't work correctly. For example, Importance has rankings 1 to 3 and when i click on a 1 in the table box the straight table does not show which people ranked 1 are on the list twice, it just reverts all names to Single. Is there a better expression to use?
Hi thanks for you suggestion. I have a straight table with just First Name and Last name and the expression i mentioned above so that i could see which names appeared twice in excel sheet. I also have a table box with all the attributes, Importance, Company etc. However when i click on importance 1, 2, or 3 the expression in my straight table no longer works.