Pivot table 2003

[matthewR]

I have a pivot table that has in the first column a product name, second column has broker with Yes or No and then count of group numbers. I am trying to (within each product) to get a percentage of Yes and a percentage of No. I don't want a percent of total but I do want a percent of total within each product. I tried percent of total and percent of column. If it is possible to do this in a pivot table, how would I do this?

[HansV]

Place product in the ROW area, broker in the COLUMN area and count of group numbers in the DATA area of the pivot table layout.
Double-click the group number field in the DATA area, and select % of Row from the Show values as dropdown.
In the Pivot Table Options dialog, clear the check boxes for Grand totals for columns and Grand totals for rows.

[matthewR]

Thank you Hans. That worked.