class interval sorting

[Anonymous]

I have created the following chart using the class function:

The calculated dimension and expression for the table are as follows;

How can the table be sorted properly starting with lower age intervals:

0 - 5

5 - 10

10 - 15 etc

regards.

Chris

[MK_QSL · Accepted solution]

Use this expression as calculated dimension

=Dual(Replace(Aggr(Class(Count(Distinct PortfolioAge),5), MCAZApplicant), '<= x <', ' -'),Aggr(Class(Count(Distinct PortfolioAge),5), MCAZApplicant))

Go to sort tab and sort by numeric Value.

[sunny_talwar]

Can you try using Dual() function:

=Dual(Replace(Aggr(Class(Count(DISTINCT PortfolioAge), 5), MCAZApplicant), '<= x <', ' - '), Aggr(Class(Count(DISTINCT PortfolioAge), 5), MCAZApplicant))

and then sort your dimension numeric ascending.

[Anonymous]

Many thanks Manish

[Anonymous]

Thank you Sunny