7 Replies Latest reply on Nov 16, 2011 8:07 PM by Michael Nealey

    Calculations to affect 'others' when not in a Top N Ranking

    Michael Nealey

      I have a parameter that allows for selection of a top 'n' based on the overall revenue or units. When not in the top 'n', the item would go into 'others'. This is working fine for me on a simple table calculation like overall revenue. However, I have tried to create a calculation such as 'growth rate', or 'market share' and the calculation for the 'others' seems not to work - rather it seems to take the next value (i.e. #11, which is outside of the top 'n' (10)).

      I'm not sure how to resolve this problem...

      (I have extracted a portion of the data so it is not the entire set).