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

    Dates in set analysis

    Phil Speight



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



      [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


      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?