Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Time in Weeks
I'm down loading a pivot table from portfolio analyzer and want the time
fields to cacluate weeks instead of days. Is there a way to do this. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Time in Weeks
You can group the dates in seven day intervals--
Select the field button for the date field On the PivotTable toolbar, choose PivotTableGroup and Show DetailGroup Enter a starting date, e.g. a Sunday or Monday date In the By list, select Days For Number of Days, select 7 Click OK Rob wrote: I'm down loading a pivot table from portfolio analyzer and want the time fields to cacluate weeks instead of days. Is there a way to do this. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Time in Weeks
I don't see the following:
Enter a starting date, e.g. a Sunday or Monday date In the By list, select Days For Number of Days, select 7 Click OK Where is this coming up? "Debra Dalgleish" wrote: You can group the dates in seven day intervals-- Select the field button for the date field On the PivotTable toolbar, choose PivotTableGroup and Show DetailGroup Enter a starting date, e.g. a Sunday or Monday date In the By list, select Days For Number of Days, select 7 Click OK Rob wrote: I'm down loading a pivot table from portfolio analyzer and want the time fields to cacluate weeks instead of days. Is there a way to do this. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting time in a Pivot Table | Excel Discussion (Misc queries) | |||
usime time in a pivot table | Excel Discussion (Misc queries) | |||
How to get pivot table Time field to appear correctly | Excel Worksheet Functions | |||
how can i secuire Sheet Same time Update the Pivot Table | Excel Worksheet Functions | |||
Stripping time in Pivot Table Column Header | Excel Worksheet Functions |