Hi, I have a few fields  and I am trying to get results on  e.g. Field1 (Person) Field2(Sales) Field3 (Location).  what I am trying to do is somehow Sum(Sales) as Sales by Person (easy part), however I need to separate the location where sales came from e.g. Vic and Other State  and table the total result for each location per person.  Person    Vic               Other  Bob           $XX               $XX   Mary         $xx                $XX Phil            $XX              $XX Thoughts? and thank you in advance ... View more

I have a search result that is tabled, and now, I am trying to find a result by percentage of the location they visit most, A B or C per person. Noting that each location A, B or C ,have sub locations designated by numbers, e.g. A1234, A2345, A4567 etc. I'm trying to find the total % based on primary designation e.g. A*, B* or C*. I can stats sum the events by sub location, but I can't seem to work out how to group the primary designations as a %. Example ID Patron Location 123 Bob A1234 234 Shirley A1234 123 Bob B4264 123 Bob C7894 234 Shirley B4356 123 Bob A4561 hopeful result Location ID Patron A B C 123 Bob X% X% X% 234 Shirley Y% Y% Y% Thoughts? Thank you all in advance for your help. ... View more