I have a pivot Table (XL2007) that returns results as follows:

Widgets Gidgets
1 20 40
2 etc
3

The values 20 and 40 are set to "sum of" in the value field settings.
Instead of sum, I would like it to return the % of the total row, i.e.
33.33% and 66.67%. Under the "show values as" tab of value field settings, I
set "show values as" % of row. But it returns 100%, not the 33.33% and
66.67%. What am I doing wrong?