Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Query
Can someone help me please?
I have a pivot table which looks like the below showing per person the number of ref #s created per date, i want it to show e.g. for Anna that she has had 2 ref #s (12456 & 37890) created on 3 seperate dates therefore the answer i want is a count of the date i.e. 3. Name Date Ref # Anna 01/02/06 12456 12/03/06 12456 14/05/06 37890 Bella 12/01/06 43978 Chris 10/02/06 21435 If this makes sense to anyone can you help me at all? Thanks in advance... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Query
A pivot table won't count unique values, but there's a workaround here,
if you're using an Excel list as the source: http://www.contextures.com/xlPivot07.html#Unique Louise wrote: Can someone help me please? I have a pivot table which looks like the below showing per person the number of ref #s created per date, i want it to show e.g. for Anna that she has had 2 ref #s (12456 & 37890) created on 3 seperate dates therefore the answer i want is a count of the date i.e. 3. Name Date Ref # Anna 01/02/06 12456 12/03/06 12456 14/05/06 37890 Bella 12/01/06 43978 Chris 10/02/06 21435 If this makes sense to anyone can you help me at all? Thanks in advance... -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OLAP Pivot table - How to show items with no data ? | Excel Worksheet Functions | |||
Pivot table "Show all data" query | Excel Discussion (Misc queries) | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
pivot table created from another pivot table | Excel Worksheet Functions | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) |