2 Replies Latest reply on Dec 14, 2016 4:32 PM by Norbert Maijoor

    Calculation (sum)/(last row value)

    A Dutta

      Data A & B comes from different tables. Table B may not have values for all the rows. I want to calculate sum(B)/last value of (A)  -> 20/700. I just want to display only the calculated value without A and B values in the worksheet.

       

      I can filter the last value as it tied up with the month, but I am having problem with the sum of B to make the calculation work.

       

       

      Thanks in advance!!