5 Replies Latest reply on Dec 19, 2013 2:31 PM by Mark Tubis

    Filter Not Applying correctly when using coloring with calculated field

    Mark Tubis

      Coming across an issue with filtering.

      I created a calculated field to color code differnet values in the worksheet.

      For the filter I created a rank. There are 20 rows of data but when I define the filter to be only the top 10 some of the data for points 11-20 gets filtered out but not all.

       

      Included an example

       

      Appeciate any suggestions on what I may be doing incorrectly to get a top 10 or if this is a known limitation/bug when using a calc field and coloring

      .Filter issue Coloring with Calculated Field.png