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


      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.