I have a table with the sales transaction. Mainly I want to look at all transactions that have same invoice number for multiple Invoice dates. And either displays them in a different table or visualize. I would be indebted if anyone can help me out with the same.
The formula seems to be working. But I want to find out all the Invoice No that have multiple unique dates. Like a pharma, medicine Invoice can have n no of the same invoice no for the date 1st Feb. But having the same invoice no on 2nd Feb would be fraudulent. I would like to pull those invoice nos that have multiple unique invoice dates.