I want to create an OLAP Table or a histogram that shows on the distribution Axis/column the case count per linked attribute and on the Occurence Axis/KPI column the number of distinct attributes that are linked to that specific case count.

See the attached OLAP Table as example:

I want to create a new table that shows in a first column the second column of the attached OLAP Table. In a second column the new OLAP Table should show the occurences of each distinct number of column two from the attached OLAP table. I indicated with the red numbers on the right the occurence count i expect to be seen in the new OLAP Table (in the new OLAP Table the number 11,040 would only be displayed once in the first column and in the second column would be a 2 because two different vendors are linked to that specific case count).

Can you help me?

Thanks in advance.