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>
</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-number | product-number | store-number | Row Labels | Count of product-number | Count of TO-number | ||
TO-0100 | a001 | S10 | S10 | 16 | 16 | ||
TO-0100 | a002 | S10 | S11 | 11 | 11 | ||
TO-0100 | a003 | S10 | Grand Total | 27 | 27 | ||
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>
</tbody>