1 Reply Latest reply: Aug 6, 2015 8:48 AM by Sinan Ozdemir RSS

    Check condition in calculated dimension

    Андрей Шепель

      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.