Comments
-
Ahh I see what you're saying. It looks likethat worked. Thank you!!
-
I tried it, but then I lose the manager's name. I need Sales Manager to remain the person's name. The team describes what industry they sell to. So I still need 2 separate fields. I just want to reroute John Smith's reps to Retail instead of Advertising. so the current columns say Sales Manager: John Smith Sales Team:…
-
That gave me the sum of all days between today and A, B, C, D, E transactions (for example, someone who transacted as recently as last week came out to 246 days due to it aggregating all of his transactions).
-
So that is basically giving me the same results as a different beast mode that I have in this set (which tells me how many days it has been since the sale). But the issue is that each transaction currently has its own line, which means sales reps have like 12 lines each. I only want one line per rep stating the # of days…
