Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I am not able to get sales territory code wise customer id count in the second table.
In the second table, i want the data like below -
Dist_TSH | STC | StCode | StateName | Count of Customer ID
Dist_TSH -> Name of Active SIO
STC -> Sales territory code in which active SIO working
STCode -> State code in which active SIO working
StateName -> Name of State in which active SIO working
Please help me to get this data so that after this I can add this data in my first table.
If you check last column in Abhi file then 5 territory codes are coming but Abhinandan is mapped only with one territory
BR-T11. |