Age Range runtime in a chart

[Riccardo]

Hello,

I want to calculate the Customer Age runtime in a chart

"Max(Year)-[Year Customer]"

I have a range table:

Range Start, Range End, Range Result

0,25,<25

26,50,26-50

etc

Dim: if(Max(Year)-[Year Customer]<=[Range Start] and Max(Year)-[Year Customer] >= [Range End],[Range Result])

Measure: Count(Customer)

Is this correct? I have to use an aggr?

[Usama]

Hi,

What expected output you want to show?

Thanks

[Riccardo]

Count of Customers, grouped by Age Range.

(ps. I can't use intervalmatch on script, 'cause I have to calculate the Customers Age on runtime)