1. Formula tool: In spoiler
2. Join tool: Joined on region
3. Sum tool: group by region, sales rep and responder, Count by store number
Spoiler (Highlight to read) Spoiler (Highlight to read) Spoiler (Highlight to read) Formula tool: If [Postal Area]>=2000 && [Postal Area]<=2019 then "R1" elseif [Postal Area]>=2020 && [Postal Area]<=2039 then "R2" elseif [Postal Area]>=2040 && [Postal Area]<=2059 then "R3" elseif [Postal Area]>=2060 && [Postal Area]<=2079 then "R4" elseif [Postal Area]>=2080 && [Postal Area]<=2100 then "R5" else "" endif
Formula tool: If [Postal Area]>=2000 && [Postal Area]<=2019 then "R1" elseif [Postal Area]>=2020 && [Postal Area]<=2039 then "R2" elseif [Postal Area]>=2040 && [Postal Area]<=2059 then "R3" elseif [Postal Area]>=2060 && [Postal Area]<=2079 then "R4" elseif [Postal Area]>=2080 && [Postal Area]<=2100 then "R5" else "" endif