Hi All,

I have a source of data formatted as below:

Retailer No. | Desc. | Value
004 | Total hours | 5000
004 | Retail hours | 2500
009 | Total hours | 6000
009 | Retail hours | 3000

I have a pivot table looking at this data source and I want to include a
field that performs the calculation '= [Retail hours]/[Total hours]'
unfortunately only the field 'Desc' is shown as a title in the pivot table to
I cant do calculate field as the data isnt setup that way.

Does anyone know a way to do what i need?

Many Thanks
--
Adam
-----------
Windows XP + Office Pro XP