View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_3_] Jim Thomlinson[_3_] is offline
external usenet poster
 
Posts: 983
Default Ratio Calculation in a Pivot Table

I need to calculate a ratio within a povot table. Here is the scenario.
Each branch buys from many warehouses. I need to know what percentage of
total purchases a branch makes comes from each individual warehouse.

Thanks in advance...