13 Replies Latest reply on Nov 3, 2013 9:23 AM by Jonathan Drummey

    COUNTD at a different aggregation? [File Attached.]

    Shawn Wallwork

      This discussion started on this thread asking about turning regular quick filters from OR construction to AND construction. Now there is another wrinkle Curtis has asked about so I've started this new thread.

       

      Jonathan, I reworked the workbook with your suggestions, and applied them to both the table and the new map. All is functioning as expected. Now curtis.johnson wants to COUNTD the Customer IDs by country. [COUNTD because in his data there may be duplicate Customer IDs in a country.] Here's the table view, red numbers indicate the desired result:

       

      Countd.png

       

      What he really wants is these figures on his Map:

       

      Map.png

       

      Any help appreciated by both of us.

       

      --Shawn