My shit

Metrics

One Tab
Note: in their HQ means that the region of domicile and the client rel region of domicile is the same
TABLE A:
MAIN PART
HQ-
Clients globally who have are selling that product in their HQ
---------------------------------------------------------------
Number of unique clients globally with one product over 25K
Sub-
Clients globally who have are selling that product in a sub
---------------------------------------------------------------
Number of unique clients globally with one product over 25K
HQ-
Clients globally who have are selling that product in a sub
---------------------------------------------------------------
Number of unique clients globally with one product over 25K
Percent of clients globals who have at least one product
HQ-
Clients globally who have one product in their HQ
---------------------------------------------------------------
Number of unique clients with > 25k in one product where their HQ is the region
Sub-
Clients globally who have are selling that product in a sub
---------------------------------------------------------------
Number of unique clients globally where they have a subsidiary product >25K in the  Sub_Region 
Total
Clients globally who have are selling a product in a HQ
---------------------------------------------------------------
Number of unique clients globally where they have a subsidiary product >25K in the  Sub_Region 

HQ-
Clients globally who have are selling that product in a sub or in a HQ
---------------------------------------------------------------
Number of unique clients with one product >25 k who do business in the region
Percent of clients globals who have at least one IB
The same calculation but the product must be IB
At Least One TSS
Same calculation where one must be TSS
At Least One TSS and IB
The number of unique clients on the above two lists.
Table B: Follow same methodology just with the data filtered by whether or not the client owns a credit product > 25K
Table C:
For each number of products x
HQ:
Number of clients who have x products who have HQ’s in the region
Number of clients with > 25k in one product who have HQ in the region
Sub:
Number of clients with subs who have x products in the Region
Number of clients with > 25k in one product  who have a sub in the Region
Total:
Count client products as having a sub product OR a HQ product in that region
Use those as the x product number
Number of Clients with total x product number
Total number of clients with > 25k in one product  who do business in the region
Table D:
Number of clients with > 25k in one product  who have a HQ in the region
Number of clients with > 25k in one product  who have a sub in the region
Number of clients with > 25k in one product  who have a sub or a HQ in the region
Table E:

Number of clients who do NOT have a sub with product X
------------------------------
Number of client with > 25k in one product  with subs in region

Number of clients who have core cash and NO liquidity in region
Number of clients with > 25k in one product in region