13 Replies Latest reply on Sep 11, 2018 9:40 AM by Hari Ankem

    Filter shouldn't apply to more than one field on the same work sheet

    Garima Vohra

      Hello,

       

      On my worksheet, there are 2 fields on Rows shelf and I am performing a dual axis on the fields to create a line chart that gives me one line of total(F1) count and another one for 2 categories. But when I apply the filter to the category (F2) field to include some it applies to my Total count field also, which is not what I want.

       

      Example - F1 = Total 10 count

                       F2= A, B, C, D, E, F, G, H, I, J count 1 for each

      when I filter out: A, B, C, D, E

      F1 shows 5

      F2= F,G,H,I,J

       

      I want the total to show 10 along with filtered out letters... Is there a way for it???

       

      Thanks,

      Garima