3 Replies Latest reply on May 16, 2018 9:12 AM by Jim Dehner

    Calculate percent difference from first of each row

    Nimrod Rosen

      Hi everybody,

      I'm trying to calculate the % difference from the first cell of each row and can't seem to get it to work

      This is how my data looks

      Capture. V1JPG.JPG

      in the attached file you will find:

      1. First table is how my data looks like

      2. Second table is how I want it to look like

       

      When I try to use the table calculation and define the calculation relative to "First", it takes the first cell in the first row for all rows. I need it to take the first cell for each row

      Any help would be greatly appreciated!