Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day!
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:
1. Distributor
2. Calculated dimension: if Distributor have more than one distinct Type business - Type business, else - set value 'Less than 1 type'
Expression:
sum(volume)
Thanks.
You can use the below function in your calculated dimension:
Hope this helps.
Thanks