//pivot - unique records .

[sansk_23]

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.

 

[Herbert Seidenberg]

Add a helper column to your source data:
http://freefilehosting.net/download/3lhhh

 

[sansk_23]

There are some errors in the columns Week & Unique , while opening the file.
Both these columns are displaying the result as "#NAME?".

rgds.

 

[Herbert Seidenberg]

The problem is with WEEKNUM()
From Help:
If this function is not available, and returns the #NAME? error,
install and load the Analysis ToolPak add-in.
Tools > Add-Ins... > Analysis Toolpak > (check box)