Hi everybody,

I have a data table which looks something like

Col A Col B Col C
Customer Year Sales
CustomerA 2006 10000
CustomerA 2007 12000
CustomerB 2006 8000
CustomerB 2007 6000
....

I would like to create a pivottable that looks like

2006 2007 Index
Customer A 10000 12000 120%
Customer B 8000 6000 75%
....

But I don't now how to have Excel calculate the index. As far as I
know calculated items/fields only work with data from different
columns.
Any help would be greatly appreciated.

DQ

Maybe:
http://contextures.com/xlPivot10.html#PctRow
from Debra Dalgleish's site.

dq wrote:

Hi everybody,

I have a data table which looks something like

Col A Col B Col C
Customer Year Sales
CustomerA 2006 10000
CustomerA 2007 12000
CustomerB 2006 8000
CustomerB 2007 6000
...

I would like to create a pivottable that looks like

2006 2007 Index
Customer A 10000 12000 120%
Customer B 8000 6000 75%
...

But I don't now how to have Excel calculate the index. As far as I
know calculated items/fields only work with data from different
columns.
Any help would be greatly appreciated.

DQ

--

Dave Peterson

Thanks Dave, I've found what I was looking for. (And thanks to Debra
to)

DQ