Pivot Table Time in Weeks

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rob - 06 Mar 2007 19:24 GMT

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.

Reply to this Message

Debra Dalgleish - 06 Mar 2007 21:24 GMT

You can group the dates in seven day intervals--
Select the field button for the date field
On the PivotTable toolbar, choose PivotTable>Group and Show Detail>Group
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

> 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.

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message

Rob - 13 Mar 2007 16:58 GMT

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?

> You can group the dates in seven day intervals--
> Select the field button for the date field
[quoted text clipped - 6 lines]
> > 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.

Reply to this Message