Hi !! I have a table like this :

Location Order Invoice Week
A 1 X1 20
A 1 Y1 20
B 2 X2 21
C 3 X3 22
C 3 Y3 22
C 3 Z3 22
C 4 X4 22

I want to have the total count of unique orders for each location for each
week.
eg .
For location A in week 20 there was only 1 order
for location B in week 21 there was only 1 order
for location C in week 22 there were 2 orders

How do i get this result with pivot table ??

regards
Sk.