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.

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

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