2 Replies Latest reply on Feb 13, 2013 10:33 AM by Pete Staley

    Dividing Sum by an Offset of another Sum

    Pete Staley

      Hello,

       

      New Tableau user here. I am trying to divide the sum from one measure by yesterday's sum of another measure. For example:

      • On 2/1/13 I have 10 apples
      • On 2/2/13 I have 5 pears

      How can I divide the 5 pears by 10 apples? In addition, I'd like to see the other similarly defined calculations, such as:

      • 2/8/13 pear total divided by 2/1/13 apple total (7 day intervals)


      Thanks for any help you can provide.

       

      - Pete