Pivot table- Calculated Field

Please assist

I want to show the % difference for the last dates entered.
item # 12/12/04 12/13/04 %Change

item1 100 110 9.1%
item2 24 35

It places this date in all the columns: 01/0/1900.

Thanks

Gwen

If you format the cells as percentage, you may see the correct results.
To format them, select the column with %Change
Click the % button on the formatting toolbar.

Gwen wrote:
> I want to show the % difference for the last dates entered.
> item # 12/12/04 12/13/04 %Change
>
> item1 100 110 9.1%
> item2 24 35
>
> It places this date in all the columns: 01/0/1900.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thank you.
Unfortunately, I haven't figured out how to get the change field into the
pivot table.

I want my pivot table to calculate the % change of the item counts on a day
by day basis.

I believe this is the formula I need for the calulated field:
(current date itemm count - yesterday's dte itm count)/current date item
coutt)*100
Any suggestions

Thanks
Gwen
"Debra Dalgleish" <[email protected]> wrote in message
news:[email protected]...
> If you format the cells as percentage, you may see the correct results.
> To format them, select the column with %Change
> Click the % button on the formatting toolbar.
>
> Gwen wrote:
>> I want to show the % difference for the last dates entered.
>> item # 12/12/04 12/13/04 %Change
>>
>> item1 100 110 9.1%
>> item2 24 35
>>
>> It places this date in all the columns: 01/0/1900.
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>