6 Replies Latest reply on Mar 4, 2016 11:22 AM by mindy.hoftender.0

    Top ten sort and filter

    mindy.hoftender.0

      Hi,

       

      I'm trying to look at the top 10 x (in this table it is zip codes) for patients by other variables...such as gender. I had a heck of a time getting top ten to work on

       

      I created Zip (count (zip codes)). I then created top ten (index()). That worked well. However, when I bring gender in, the data either shows only the top 10 for females, or will sort the data in odd ways...

       

      Do I have to make two different tables, one for each gender? or is there a way to show the top ten overall zip codes broken down by how many are female and how many are male?

      Thanks!