Check condition in calculated dimension

Anonymous — Thu, 06 Aug 2015 11:37:11 GMT

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.

Re: Check condition in calculated dimension

sinanozdemir — Thu, 06 Aug 2015 12:48:03 GMT

You can use the below function in your calculated dimension:

Hope this helps.

Thanks