4 Replies Latest reply on Jan 31, 2017 8:57 PM by Tim Cooper

    TopN from one as of date, applying results to time series

    Tim Cooper

      Hello All,

       

      I am after a method where I can have the Top 5 dimensions by Sum(Measure) from a specific date applied to a time series of dates..

      Firstly, I need this to be used in a batched workbook (automated), so an action filter is out of the question

       

       

      So.. below are the Top 5 as of 01st December(date applied to context)

       

      I now want those above 5 Dimensions to be a filter on below,,, Preferably all this happens in one worksheet

       

       

      Thanks!