2 Replies Latest reply on Jun 22, 2012 1:24 PM by Daniel Carr

    Divide results from same summary field but with different filters for numerator and denominator

    Daniel Carr

      Hello,

       

       

      We have the following issue:

       

       

      • We have US States in ‘Rows’.
      • We have Product Name in ‘Columns’
      • Our summary info is ‘Sales’

       

      So, grid looks like this:

       















       

      State


       

       

      Books


       

       

      Computers


       

        New York
       

       

      200


       

       

      500


       

       

      California


       

       

      400


       

       

      1000


       

       

       

       

       

       

      We would like to divide the Books by Computers for each
      state.  i.e. For NY 200/500.  For CA 400/1000.

       

       

      We cannot figure out how to create a formula which does this
      since it is Sales/Sales (where the numerator and denominator just have
      different filters.)

       

       

      Any help you can offer is greatly appreciated.

       

       

      Thanks,

       

       

      Dan