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.