Hi I have a 24 month spreadsheet, and would like to make 2 new calculated
columns, for dates adding 12 months together each, is this possible thanks
tim
the spreadsheet is date, customer product dollars
Hi I have a 24 month spreadsheet, and would like to make 2 new calculated
columns, for dates adding 12 months together each, is this possible thanks
tim
the spreadsheet is date, customer product dollars
Hi Tim,
This is possible - you have two options:
1) On the Pivot Table toolbar, Formulas>Calculated Field. In the "name"
field, enter the name you want to call it, and in the "Formula" field, enter
the formula you want it to calculate (Sep04+Oct04+Nov04 etc.) and hit OK.
Create all the new fields you want using this screen. When you go back to
you Pivot Table, these new fields will be available in your field list, and
you can place them as required.
2) On your data table, insert a "Year" column, and include this in the pivot
table. This will allow you to drill down or drill up as required.
Hope this helps
Warm regards
Sunil Jayakumar
"Tim" <[email protected]> wrote in message
news:[email protected]...
> Hi I have a 24 month spreadsheet, and would like to make 2 new calculated
> columns, for dates adding 12 months together each, is this possible thanks
> tim
>
> the spreadsheet is date, customer product dollars
>
www.ayyoo.com/credit-cards.html
Hi Sunil Thanks for the reply. I had tried this, but find I can not make
the new field a column, I can only put it in as data. Thanks Tim
"Sunil Jayakumar" <sunil.jayakumar[at]gmail.com> wrote in message
news:%[email protected]...
> Hi Tim,
>
> This is possible - you have two options:
>
> 1) On the Pivot Table toolbar, Formulas>Calculated Field. In the "name"
> field, enter the name you want to call it, and in the "Formula" field,
> enter the formula you want it to calculate (Sep04+Oct04+Nov04 etc.) and
> hit OK. Create all the new fields you want using this screen. When you go
> back to you Pivot Table, these new fields will be available in your field
> list, and you can place them as required.
>
> 2) On your data table, insert a "Year" column, and include this in the
> pivot table. This will allow you to drill down or drill up as required.
>
> Hope this helps
>
> Warm regards
>
> Sunil Jayakumar
>
>
> "Tim" <[email protected]> wrote in message
> news:[email protected]...
>> Hi I have a 24 month spreadsheet, and would like to make 2 new calculated
>> columns, for dates adding 12 months together each, is this possible
>> thanks tim
>>
>> the spreadsheet is date, customer product dollars
>>
>
> www.ayyoo.com/credit-cards.html
>
>
If you want to total each year, you could group the date in the pivot
table, by year and month. Display the subtotal for the Year field, and
it will show the 12 month total.
There are grouping instructions here:
http://www.contextures.com/xlPivot07.html
Tim wrote:
> Hi I have a 24 month spreadsheet, and would like to make 2 new calculated
> columns, for dates adding 12 months together each, is this possible thanks
> tim
>
> the spreadsheet is date, customer product dollars
>
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks