View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Marc
 
Posts: n/a
Default Pivot tables and column data

Hello -

I have a pivot table and in the column area I have a field called type. I
have two types that appear RD and RQ. My first issue is I don't want them
added together, and want to get rid of the grand total field in each row of
data. My second question is I want to show the results of RD/RQ as a
percentage and want to show the values of RQ and RD as well as the %.

Thanks for any help.

Marc