Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need help displaying new contacts for each year on a pivot table. Below is a picture of what I have so far. I need each contact to show only once and that is when it was first created. What I have now shows the contact name for each year it was contacted but I would like it to show for only the year it was created. Thanks for suggestions
If i understand correctly, just do like this?
FirstSortedValue([Contact Name], -[Contact Year], 1)
Thanks for your reply but its not giving me what I want. I need values in each year to be unique. That is, a contact name should appear only once and that is on the year the contact was created.