3 Replies Latest reply on Jul 4, 2016 9:32 AM by Yuriy Fal

    Creating Top N Percent Difference Across Months

    Yuri Kuzmycz

      Hello All:

       

      Hopefully this is pretty easy to pull off.  I have a set of actual and plan monthly cost data per service per month.  I've used the quick calculation functionality to determine the % difference month over month as compared to the prior month.  I'm unable to, though, capture the top N % for the latest month.  Ideally I'd like to only see June's top 10 largest % difference service costs.

       

      I've created a parameter TopN and tried to create a set from the service.  The % difference measure does not show up as an option within the set configuration.  What am I missing?

       

      Many thanks in advance!