Count unique values in pivot table or with formula

[iwian]

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?

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>

 

[AhoyNC]

Below is a formula way. This is an array formula and must be entered with CTRL-SHIFT-ENTER.
Also here is a link to using a pivot table. See second answer there is a "202" by it.
https://stackoverflow.com/questions/11876238/simple-pivot-table-to-count-unique-values

Excel Workbook
	A	B	C	D	E	F	G	H
1	TO-number	product-number	store-number			Row Labels	Count of product-number	Count of TO-number
2	TO-0100	a001	S10			S10	2	9
3	TO-0100	a002	S10			S11	1	11
4	TO-0100	a003	S10			Grand Total
5	TO-0100	a004	S10
6	TO-0100	a005	S10
7	TO-0100	a006	S10
8	TO-0100	a007	S10
9	TO-0101	a001	S11
10	TO-0101	a002	S11
11	TO-0101	a003	S11
12	TO-0101	a004	S11
13	TO-0101	a005	S11
14	TO-0101	a006	S11
15	TO-0101	a007	S11
16	TO-0101	a008	S11
17	TO-0101	a009	S11
18	TO-0101	a010	S11
19	TO-0101	a011	S11
20	TO-0102	a001	S10
21	TO-0102	a002	S10
22	TO-0102	a003	S10
23	TO-0102	a004	S10
24	TO-0102	a005	S10
25	TO-0102	a006	S10
26	TO-0102	a007	S10
27	TO-0102	a008	S10
28	TO-0102	a009	S10
Sheet