View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
vbasean vbasean is offline
external usenet poster
 
Posts: 10
Default Need running percentage in pivot table

I've a pivot table with results:

Washington Michigan
Apples, Oranges, Grapes Total| Apples, Oranges, Grapes Total|
234 345 23 602 198 275 5 478

I want to add a percentage of each fruit in each state

Washington Michigan
Apples, Oranges, Grapes Total| Apples, Oranges, Grapes Total|
234 345 23 602 198 275 5 478
39% 57% 4% 100% 41% 58% 1% 100%

thanks in advance.