4 Replies Latest reply on Nov 20, 2018 9:31 PM by hari krishna vangapandu

    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!