Unique values in data tables

[Amphagory]

I have a bunch of documents on business. One of their properties is customer_id.
The same customer_id might now up in several documents, but I would only like to display unique customer_id in data table.

Ideally the data table would look like this:
Now:

Business1    customer_id1
Business1    customer_id1
Business1    customer_id1
Business1    customer_id2
Business2    customer_id7
Business2    customer_id7
Business2    customer_id5
Business2    customer_id8
Business2    customer_id8
Business2    customer_id8
Business2    customer_id8

Desired:

Business1    customer_id1
Business1    customer_id2
Business2    customer_id7
Business2    customer_id5
Business2    customer_id8

Mike

[LeeDr (Lee Drengenberg)]

If you use a Terms aggregation to "Split rows" on the first field, and then add another Terms aggregation to "Split rows" on the second field, you should only get a single row with each combination of those 2 fields, along with a count for how many instances of those combinations there are;