6 Replies Latest reply on Aug 2, 2016 2:47 PM by Yan Gonzalez

    How can I display only the last record of a calculated field?

    Yan Gonzalez

      Hello guys! Such a pleasure to be here! Yan Gonzalez, from Paraguay here. Well, I'm working on this report, calculating the current yield (CY) on traded bonds at my local stock exchange (where I work). The CY is a calculated field which extracts info from 2 .xls: One withe the Operation date among other stuff, and another with the bond's rating, among other stuff too.


      Thing is, once I have the CY, I want to take the value from the last operation only, so I can have a yield curve for each bond rating. I tried a few things, like the Last() filter, but with no results. I'm really a newbie to this kind of filtering, so any help would be more than welcome!

       

      Thanks in advance!

       

      P.S.: The attached workbook is a small sample, the full tables have more than 6000 operations and 90 companies.

       

      https://public.tableau.com/static/images/Cu/CurrentYieldTest/CurrentYield/1.png