Calculated dimension by conditional aggregation

shaybitton — Thu, 16 Aug 2018 08:01:53 GMT

Hi there,

I have 3 measures ,Year1 ,Year2 ,Year3

I have 2 dimensions Channel and Agent.

i want to create a calculated dimension combining the Channel Dimension in the logic below

if Year1>10 or Year1 <-10 or Year2>10 or Year2 <-10 Year2>10 or Year2 <-10

(True Section)

Then check if (Match(Organization,'1','2','3'),Channel,'Building')

(False Section)

if (Match(Organization,'1','2','3'),ADJ,'Building')

Simplifying it:

Organization = 1,2,3 represent Paint Organization

if the 3 measures are greater than 10 or less than -10

check if the line(including the Agent dim) associates to Paint, if so use Channel dim If not associate it to 'Building'

if the line doesn't meet the condition

check if the line(including the Agent dim) associates to Paint, if so use ADJ, If not associate it to 'Building'.

Thank you for your help,

Shay

Re: Calculated dimension by conditional aggregation

PrashantSangle — Thu, 16 Aug 2018 08:15:48 GMT

instead of dimension try it in expression window..

if(

Year1>10 or Year1 <-10 or Year2>10 or Year2 <-10 Year2>10 or Year2 <-10,

if(Match(Organization,'1','2','3'),Distinct Channel,'Building'),

if (Match(Organization,'1','2','3'),Distinct ADJ,'Building')

)

Regards