12 Replies Latest reply: Mar 29, 2017 8:08 AM by Phil Speight RSS

    Dates in set analysis

    Phil Speight

      Hi

       

      I have a set analysis that looks at the min & max date (as below)

       

      (Sum({<

      [Turnover.Start_Month]={"$(=Date((Min(Turnover.Start_Month)), 'DD/MM/YYYY'))"}

      >} [Turnover.First_Day_of_Month_Count]))

       

      This works fine without the added dimension of fiscal year, However I now need to bring in the Fiscal year as a dimension in my pivot table, but my table shows as below for the start and end headcount.

       

           

      Dates.FiscalYear     Start      Headcount     End      Headcount          Overall     Leavers
      15/1666080844
      16/1707067707

       

      The set analysis uses the whole range to work out the min & max, but I need to show a start and end headcount for each year.  Any ideas?

       

       

      Thanks

       

       

       

      Phil