4 Replies Latest reply on Apr 9, 2018 6:05 AM by Zhouyi Zhang

    To find the difference between same row two column data in next row of second column

    sagar ghonge

      Dear Experts,

       

      Please help me to build below logic in tableau

      1) key figure:  Allocate  will have formula min (capacity,Pre allocate) which i have already incorporated

      2) key figure: Pre allocate will have first row and first column as total requirement number which i have achieved

      Help me to achieve from second row of pre allocate to calculate previous row Pre allocate minus previous row allocate i.e 350-100 and so on

       

      Please find the attached excel file for your reference

       

       

       

      Thanks

      Sagar G