I have 2 pivot tables, both calculating the sum of occurences of different items sold. I am trying to establish a ratio relationship between the 2.
For example:
Pivot Table 1: Store Name..# of product 1 sold
Pivot Table 2: Store Name..# of product 2 sold
I want to find out what the ratio is between product 1 and product 2 (3:1). I'd rather not have to use a percentage. Any formulas out there to do this?
For example:
Pivot Table 1: Store Name..# of product 1 sold
Pivot Table 2: Store Name..# of product 2 sold
I want to find out what the ratio is between product 1 and product 2 (3:1). I'd rather not have to use a percentage. Any formulas out there to do this?