Thanks:  0
Likes:  0

# Thread: Calculate a ratio from Pivot Table results

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?

2. 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"

3. Hi again
This might be better

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

Tom

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•