I'm using Tableau 8.3 and I'm trying to find out how to group on each of the values that I find after making a "count of distinct values".

To illustrate the case I have made a fictive dataset that includes 58 rows (buys), 7 different IDs (customers) and 5 different products. Then I have made a count distinct to find out how many of the 5 different products each ID has bought. It looks like this.

ID1 = 4

ID2 = 4

ID3 = 5

ID4 = 4

ID5 = 3

ID6 = 4

ID7 = 2

Now I want to turn the view around and find out how many of the IDs who have bought X different products. It should ultimately look like this.

2 = 1

3 = 1

4 = 4

5 = 1

I hope to find a solution by posting here! Thank you,