- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
lain179
Communicator
02-20-2014
04:42 PM
1 Solution
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
lain179
Communicator
02-21-2014
11:07 AM
Thanks to somesoni2
base search | stats count by A,B,C | fields - count| sort B,C,num(A) | stats list(A) by B,C
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
lain179
Communicator
02-21-2014
11:07 AM
Thanks to somesoni2
base search | stats count by A,B,C | fields - count| sort B,C,num(A) | stats list(A) by B,C
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
lain179
Communicator
02-21-2014
11:07 AM
Awesome!!!! It worked. Thank you.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

somesoni2
Revered Legend
02-21-2014
06:41 AM
If you're not worried about the count and just want to list values, give this a try.
your base search | stats count by A,B,C | fields - count| sort B,C,num(A) | stats list(A) by B,C
Since duplicates are already removed by first stats, list and values will return same set of data.
