//pivot - unique records .
 

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.

//pivot - unique records .
 

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

//pivot - unique records .
 

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" wrote:

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

//pivot - unique records .
 

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)