4 Replies Latest reply on Mar 12, 2014 6:01 AM by Kiran v

    How to calculate percent difference month-to-month but for for the right measures?

    Kiran v

      I have been a decent tableau user and couldn't break this calculation puzzle. I am pretty sure there is a way to do it just cannot figure out how.

       

      Any help is greatly appreciated. Attached is a sample workbook.

       

      All I am looking for is percent difference in price increase in e.g. march 2013 from mar 2012 but A to A relationship and B to B relationship. I have tried every possible combination in the table calculation but it seems to calculate the previous row all the time. And doesn't skip a row to detect an A in the previous pane.

       

      Please help.