Hi,
Question. So I have a column called RFPID, its a unique code used for opportunities of the Sales team. Sometimes 2 or 3 opportunities have the same RFPID so best to use the distinct count to count non duplicate RFPIDs. On the table that I will create, I need to show the won opportunities and divide it to those opportunities that were sent for 2023. How will I divide the won / sent opportunities if the data that I will use are sent date, won date, RFPID and status only. I think I need a measure to calculate this but will it allow to calculate if Im going to use the RFP ID won date to 2023(which is filtered to sent date and won date = 2023 and RFP ID sent date(which is filtered to sent date 2023 and open won date)?
Thanks for assisting
It's difficult to visualise your data and suggest a solution with a file to play with. Can you please upload a file (without confidential information) with enough data to comprehend what you are working with?
