Pivot table- Calculated Field

  • Thread starter Thread starter Gwen
  • Start date Start date
G

Gwen

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