cancel
Showing results for
Did you mean:
Partner - Contributor III

## Calculated dimension by conditional aggregation

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)

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'.

Shay

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'),