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