Hello, how can i count unique TO-Numbers for every store from the example
Pivot return 16 for S10 but TO-numbers are 2, and product numbers are 9
Is it possible to be counted in other sheet with formula?
<colgroup><col style="mso-width-source:userset;mso-width-alt:2852;width:59pt" width="78"> <col style="mso-width-source:userset;mso-width-alt:4022;width:83pt" width="110"> <col style="mso-width-source:userset;mso-width-alt:3437;width:71pt" width="94"> <col style="width:48pt" span="2" width="64"> <col style="mso-width-source:userset;mso-width-alt:3364;width:69pt" width="92"> <col style="mso-width-source:userset;mso-width-alt:6144;width:126pt" width="168"> <col style="mso-width-source:userset;mso-width-alt:4973;width:102pt" width="136"> </colgroup><tbody>
[TD="width: 78"]TO-number[/TD]
[TD="width: 110"]product-number[/TD]
[TD="width: 94"]store-number[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 92"]Row Labels[/TD]
[TD="width: 168"]Count of product-number[/TD]
[TD="width: 136"]Count of TO-number[/TD]
[TD="class: xl63"]S10[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]16[/TD]
[TD="class: xl63"]S11[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]11[/TD]
[TD="class: xl63"]Grand Total[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]27[/TD]
</tbody>
Pivot return 16 for S10 but TO-numbers are 2, and product numbers are 9
Is it possible to be counted in other sheet with formula?
TO-0100 | a001 | S10 | |||||
TO-0100 | a002 | S10 | |||||
TO-0100 | a003 | S10 | |||||
TO-0100 | a004 | S10 | |||||
TO-0100 | a005 | S10 | |||||
TO-0100 | a006 | S10 | |||||
TO-0100 | a007 | S10 | |||||
TO-0101 | a001 | S11 | |||||
TO-0101 | a002 | S11 | |||||
TO-0101 | a003 | S11 | |||||
TO-0101 | a004 | S11 | |||||
TO-0101 | a005 | S11 | |||||
TO-0101 | a006 | S11 | |||||
TO-0101 | a007 | S11 | |||||
TO-0101 | a008 | S11 | |||||
TO-0101 | a009 | S11 | |||||
TO-0101 | a010 | S11 | |||||
TO-0101 | a011 | S11 | |||||
TO-0102 | a001 | S10 | |||||
TO-0102 | a002 | S10 | |||||
TO-0102 | a003 | S10 | |||||
TO-0102 | a004 | S10 | |||||
TO-0102 | a005 | S10 | |||||
TO-0102 | a006 | S10 | |||||
TO-0102 | a007 | S10 | |||||
TO-0102 | a008 | S10 | |||||
TO-0102 | a009 | S10 |
<colgroup><col style="mso-width-source:userset;mso-width-alt:2852;width:59pt" width="78"> <col style="mso-width-source:userset;mso-width-alt:4022;width:83pt" width="110"> <col style="mso-width-source:userset;mso-width-alt:3437;width:71pt" width="94"> <col style="width:48pt" span="2" width="64"> <col style="mso-width-source:userset;mso-width-alt:3364;width:69pt" width="92"> <col style="mso-width-source:userset;mso-width-alt:6144;width:126pt" width="168"> <col style="mso-width-source:userset;mso-width-alt:4973;width:102pt" width="136"> </colgroup><tbody>
[TD="width: 78"]TO-number[/TD]
[TD="width: 110"]product-number[/TD]
[TD="width: 94"]store-number[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 92"]Row Labels[/TD]
[TD="width: 168"]Count of product-number[/TD]
[TD="width: 136"]Count of TO-number[/TD]
[TD="class: xl63"]S10[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]16[/TD]
[TD="class: xl63"]S11[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]11[/TD]
[TD="class: xl63"]Grand Total[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]27[/TD]
</tbody>