Hi Don,

Clever solution--thanks for your effort. It works great as long as I don't
mess around with filters or hide / show options in the pivot table, or
refresh the pivot table with additional source data, etc.

"Don" wrote:

This is a hard one for just pivot tables.

I would do the total by region in one pivot table then for the pivot table
below create two columns
1) =IF(A3="",E2,A3) this will copy down the region from the pivot tables
2) =C3/VLOOKUP(E3,$F$3:$G$4,2) This will look at the number in the sales
column (c3) and divide it by looking at your table from F3:G4 and finding out
the total for that region

F g
North 100
West 200

"Ted M H" wrote:

I need to get my pivot table to return a percent of subtotal instead of a
percent of column. Here's what I want:

Region State Sales Percent of Sales
North Montana 10 10 %
Idaho 90 90 %
North Total 100 100 %
West Calif 50 25 %
Oregon 100 50 %
Arizona 50 25 %
West Total 200 100%

I can easily do this using the Show Value As % of Column option with field
settings for the Sales Field, but as the description implies this gives me
just the percent of of the grand total for the column rather than for the
subtotals.
Is it possible to do what I want here?