Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting date for pivot table
hello
the data in my spreadsheet is with datetime. when i create a pivot table, it creats multiple rows for data with same date. when i tried to change the format, it did not help how can i create a pivot table that does not create multiple rows for data with sme date when my souce excel data is in datetime. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting date for pivot table
After you create the pivottable, you can:
rightclick on the date/time header. Choose Group and Show Detail Then choose Group and group by Days (unselect any other options) Or you could do this: Insert another column with just the date: =int(a2) and format it as a date. And then pivot on that extra helper column. Seede wrote: hello the data in my spreadsheet is with datetime. when i create a pivot table, it creats multiple rows for data with same date. when i tried to change the format, it did not help how can i create a pivot table that does not create multiple rows for data with sme date when my souce excel data is in datetime. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting date for pivot table
Hi,
Of course another alternative is to create a formula in a blank column of the data range which only returns that date. =INT(A1) for example. Then use this as your row field. Another option is to select the Date column in you raw data and choose Data, Text to Columns, Fixed Width, Next, make sure the line in the preview pane is in the correct place to the right of the date portion. Click Next, select the time column in the preview pane and select Do not import (Skip). Click Finish. This will eliminate the times leaving only the dates. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Seede" wrote: hello the data in my spreadsheet is with datetime. when i create a pivot table, it creats multiple rows for data with same date. when i tried to change the format, it did not help how can i create a pivot table that does not create multiple rows for data with sme date when my souce excel data is in datetime. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table sorts date as Alpha, not as Date | Excel Worksheet Functions | |||
Date formatting on a Pivot Chart's Data Table | Charts and Charting in Excel | |||
Pivot Table Formatting | Excel Worksheet Functions | |||
Pivot table formatting | Excel Discussion (Misc queries) | |||
Pivot Table border formatting and pivot chart formatting | Excel Discussion (Misc queries) |