12 Replies Latest reply on Oct 4, 2017 12:04 AM by ankit.ravi

    Ratio between 2 rows from the same dimension using the same measure

    ankit.ravi

      I want to find ratio  between 2 rows from the same dimension. I have attached a sample workbook below. I tried using if else to get this but was unsuccessful in achieving the goal.

       

      In my case I have many unique rows and would like to have a way where I can look at the ratio and difference between 2 unique rows.

       

      Please do let me know if I need to provide any additional information to solve the problem.

       

      Thanks in advance.