View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] evlai@hotmail.com is offline
external usenet poster
 
Posts: 2
Default Percentage of subtotal with Pivot

Hi All,

I need help with below.

My source data is showed as:
Week| Department | Agent | Options
1 Sales Alice Agree
1 Sales Alice Agree
1 Sales Alice Disagree

i would need to get the formula for the percentage of number of
agree/total options. Anyone can help?