Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel |