4 Replies Latest reply on Aug 10, 2017 11:37 AM by Shayne Croke

    Table Calculation Function Help Needed

    Shayne Croke

      I am new to table calculation functions so I hope this is an easy one.  I can see all of the data I need in the table below but can't figure out how to use lookup() to get the values I need.  First,  I want to sum across rows for only 'CFR Carryover' and 'CFR MTD Allocated' (not including total column) to get 'Total CFR Carryover + Allocated.'  Then, I want to divide the total 'CFR MTD Shipped' by 'Total CFR Carryover + Allocated' to get 'MTD Shipped vs. Carryover & Allocation.'  I included a screenshot of my table in Tableau and what I am trying to do in Excel.  Thanks in advance for your help!