14 Replies Latest reply on Apr 4, 2016 5:11 AM by Koushik Neelakantha

    Need the logic urgently..Please Help

    Koushik Neelakantha

      Hello All,

       

      I need to show the rectangle box.

       

      Logic:

       

      à$29.7M to go to YTD FBP= 74.9 -39.6(IBP - Local Sales)

       

      à$35.3M to go to YTD IBP=69.3-39.6( FBP- Local Sales)

       

      Please find the attachment.

       

      Note : IBP and FBP made cumulative in Database itself. Local sales cumulative we made it in tableau(taking running Total).

       

      Regards,

      Koushik.