3 Replies Latest reply on Dec 21, 2017 1:03 PM by swaroop.gantela

    Top/Bottom N includes all values just in Top N

    Joshua Preston

      Hello - I have temperature changes over a period of time for countries and there's a single positive or negative value for each country. (temps rose or fell).

       

      I'm trying to show the top/bottom N of the amount of temp change (float). But when trying to include a combined set of top/bottom N in the filter I get all the values in the Top N.

       

      Is this being caused by the negative numbers (lower temps)? 10.4 twbx attached with current sheet displayed. thanks!