0 Replies Latest reply on Apr 26, 2012 10:54 AM by Jessica Cha

    Filters affecting primary group creation

    Jessica Cha

      Hi,

       

      I have a workbook with many sheets/dashboard using 4 global filters. (Field 1,2,3,4).

      Also I have a secondary database that I bring into link certain codes and I create the primary code from this.

      however, I noticed that if I have data like the following (simplified to only use one global filter - field 1):

       

      Field1           Code(linked to both database)

      1                    111

      1                    222  

      1                    333

      2                    444

      2                    555

      3                    666    

      3                    777

      3                    888

      3                    999    

       

      and the code mapping sheet looks like the following:

      Name           Code(linked to both database)

      Adam                    111

                                  555

      Jenny                    222

                                  777

                                  999

      Michael                 333

      John                     444

                                  666

      James                  888

      John                    666    

       

      With the global filter [Field1=1] applied, I will only see the following in the code mapping sheet.

       

      Name           Code(linked to both database)

      Adam                    111

      Jenny                    222

      Michael                 333

       

      And if I create the primary group from the Name column, it would only contain those 3 names with 3 codes.

      It is easily noticeable when I have a small data like this, but when I have a very big data set, it's not easy to see that this is happening.

      So in order to avoid this problem, I have to get rid of all the global filters, create primary groups, and then put the global filters back to the sheets.

       

      Along with my suggestion on automatically updating the primary groups when the secondary databases are updated, can you also take above into consideration and make changes please?

       

      Thank you!

       

      Jessica