Pivot table

[Guest]

hi

I am trying to create a Pivot chart in Excel. Getting chart from another
sheet in same workbook.

I have data like this


Date Source Status Count(*)

1/1/2007 A C 5
1/1/2007 A D 10
1/1/2007 A E 22
1/2/2007 B C 1
1/2/2007 B D 5
1/2/2007 B E 12
...
.....
....
So on





I put date on page Area, Source to Row area and Status to colum are.


when I drop down date it shows 1/1/2007 three times, because of date value


is there anyway to tell Excel to display distinct of date,source,status


Thanks
Kal

 

[Aqib Rizvi]

Kal
I tried this and it gives correct answer to me. The date value for
1/1/2007 is 39083.
Do you have date with time as well? Try to enter the date as
=Date(YYYY,MM,DD) and runt the table, it will work.
Best Regards
Aqib Rizvi