Excel Pivot Table: "% of " field setting does not work

[jason]

Hi all,

Can someone please tell me how to make the "% of"
functionality in the field settings dialog box work in
Excel when I connect to a cube in Analysis Services?

Below is an example of what I am trying to do:

Using the foodmart 2000 Sales cube, I have the following
pivot table:
Measure: Unit Sales
Store Type: Columns
Product Family: Rows

If I select "Field Settings" on the Unit Sales measure,
click on "Options", select "% Of" in the "Show data as:"
drop down list, and then select "Product Family" as
the "Base Field", and "Food" as the "Base Item:".

I get #NA for all of the values. Can someone please tell
me how to fix this?

Thanks in advance,
Jason
..