PIVOT chart us not able sort

[Anonymous]

Age Slot	# of Incidents
< 5 Days	65
5 to 10 Days	55
11 to 30 Days	124
> 30 Days	509
Total	753

Hi I have this PIVOT chart object. I am able to sort it perfectly like shown above. The AGE SLOT column is in order.

But when I do some selections - Like if I am selecting some team name then this order is getting changed as shown below.

Any specific reasons?

Age Slot	# of Incidents
11 to 30 Days	4
> 30 Days	5
< 5 Days	5
5 to 10 Days	6
Total	20

[marcus_sommer]

Have you tried it with a dual-field from [Age Slot]?

dual(string-value, numeric-value)

- Marcus

[#3]

Hi Vijay,

go to Sort -> check Expression ->  type

sum({1} Age)

Hope this might help

[Anonymous]

Hi,

Check in Sort tab, might be you have opted ascending in Numeric value.

[Anonymous]

Hi Marcus,

What is dual(string-value, numeric-value) and where I have to use it?

[MayilVahanan · Accepted solution]

Hi

Try like this

Load *,

If(Days < 5, Dual('<5 Days', 1),

If(Days <= 10, Dual('5 to 10 Days', 2),

if(Days <= 30, Dual('11 to 30 Days', 3), Dual('>30 Days', 4))) as "Age Slot"

from datasource;

Then

In Pivot table -> Sort , use Num([Age Slot]) in Expression  and Ascending.

Hope it helps