I have test model to try check some thing:
I have three fields: Distributor, Type business, Volume
I need to create pivot table with such dimensions:
2. Calculated dimension: if Distributor have more than one distinct Type business - Type business, else - set value 'Less than 1 type'