Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
bhuprakash
Creator II
Creator II

Pivot - Count of Customer no.

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.


1 Reply
isingh30
Specialist
Specialist

Can you share your data in excel file?

Thanks.