ExcelBanter - View Single Post

Jill1

No, I tried that before.

"Debra Dalgleish" wrote:

If you change the data field's summary function to Max, instead of Sum,
and format the data field as Date, do you get the results you want?

Jill1 wrote:
Thanks Debra, I tried your suggestion but I still get the same results !

"Debra Dalgleish" wrote:

Those don't look like real dates (e.g. 12/12/2006), so Excel treats them
as text. In the pivot table's data area, text from the source data isn't
displayed.

On a copy of your worksheet, you could try replacing all the periods
with forward slashes, and create a pivot table from the revised data.

Jill1 wrote:

Hi

I have the follwoing data in a spreadsheet

Emp Event Date
1 A 01.01.06
1 B 01.02.06
2 A 01.01.06
3 B 01.03.06

I would like to use a pivot table to create the following :-

Event A B
Emp
1 01.01.06 01.02.06
2 01.01.06
3 01.03.06

Instead I get :-

Count of Date Event
Emp A B Grand Total
1 1 1 2
2 1 1
3 1 1
Grand Total 2 2 4

If I go into field settings I can change the date to show sum or count etc.
but I would like to just display the date. Is this possible ? Any help
appreciated.

Thanks

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html