3 Replies Latest reply on Dec 29, 2016 12:54 PM by Bobby Souza

    Applying filter to the first level of hirearchy

    ayesha.iqbal

      Hi,

      I want to use the filters for level 1 only and then expand the hierarchy without the pre-conditions or filters changing, any ideas?

      Hierarchy has field 1 and field 2

      Have:

      Field 1      Condition 1    Condition 2

      Grade 1         1.8              1.6

      TOTAL              3                3

       

      want: (Filter condition 1 >1.5,   condition 2 >1.2 applied to field 1 only and not on field 2)

       

      Field 1          Field 2      Condition 1    Condition 2

      Grade 1       student a             1.4               1.9

                          student b             0.1                 1.3

                           student c              2                   1.4

      Total            3

       

      Note student b should not be filtered out .

      My query as of now is filtering out student b based on the filters and my total is not 3 but 2 when I add field 2.

       

      Help?