Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Calculate a ratio from Pivot Table results

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi again
    This might be better

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

    Tom

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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