1 Reply Latest reply on Aug 1, 2017 1:19 PM by Deepak Rai

    Price Volume Analysis

    Nathan Wu

      Hi all,

       

      I'm looking to create a calculated field where I can take the (previous years price - current years price) * current years volume. I tried doing this with Lookup([Price], -1), but it only gives me the price of the row above (which is a completely different product).

       

       

      Tableau Help Question.png
      I'm using for the formula (ZN(SUM([Ext Net Amt]))-LOOKUP(ZN(SUM([Year])),-1))


      Thanks