Calculate a ratio from Pivot Table results

Karen H · Mar 26th, 2002, 11:51 AM

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?

Tom Schreiner · Mar 26th, 2002, 12:31 PM

Hi

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?

Product1/Product2

=abs(Product1/Product2) & ":1"

Tom Schreiner · Mar 26th, 2002, 12:41 PM

Hi again
This might be better

=TEXT(ABS(Product1/Product2), "###.#")&":1"

Tom

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 26th, 2002, 11:51 AM	#1
Karen H New Member Join Date: Mar 2002 Posts: 1	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?

Mar 26th, 2002, 12:31 PM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi 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? Product1/Product2 =abs(Product1/Product2) & ":1"

Mar 26th, 2002, 12:41 PM	#3
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi again This might be better =TEXT(ABS(Product1/Product2), "###.#")&":1" Tom