9 Replies Latest reply on Feb 2, 2016 6:59 AM by Mark Fraser

    Restricting months in view for one measure

    Bex Hurrell

      Hi there,

       

      I am trying to replicate a report in Tableau which I used to have in Excel. I have two Excel data sources, one for absence and one for staff in post (FTE). I want to show 12 months worth of absence data but only the latest month's FTE (staff in post) data. Can anyone tell me how to do it? I have attached an example... so in the example I want to show Jan - Dec Absence % but only Dec FTE in the table. At the moment, obviously I only get 12 months of each.

       

      Many thanks.