5 Replies Latest reply on Nov 27, 2018 3:35 AM by Zhouyi Zhang

    Using the latest notes/commentary field in my table calculation

    Catarina Tran

      Hi Tableau Experts,

       

      I have a sample workbook that compares revenue for a given product line. There is a commentary field for the latest period and there may be commentary from the prior period.

       

      I would like to be able to use only the latest commentary from the current period while displaying the table calculation on one row versus multiple rows.

       

      Initially, I was going to use a level of detail calculation: {FIXED [Product]: Max [Forecast Date]} but it filters out the revenue from the prior period, which I don't want.

       

      Workbook is attached. Any help would be greatly appreciated.