Show number of duplicates in front of each duplicate row
I have a straight table with a 1st column with distinct values and a 2nd column with values (ID) that are sometimes repeated. How can I show, in a 3rd column, the number of different entries that have the same ID in front of each of those entries (as shown below)?
Total number of lines with that ID
This is a straight table that should change depending on the selection made on list boxes (i.e., depending on, for example, the week I select, the number of entries with a certain ID will change...)
Re: Show number of duplicates in front of each duplicate row
I have both in a Table Box that somebody else created (that gets the values from the company's internal system). I created a straight table because I need not only some values that are in the table box (such as Date and ID) but also some columns with calculated expressions.