If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
//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. |
#2
|
|||
|
|||
//pivot - unique records .
|
#3
|
|||
|
|||
//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 |
#4
|
|||
|
|||
//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) |
Thread Tools | |
Display Modes | |
|
|