How to sort a field in the order i want??

[#1]

Hi!

I,m trying to sort a field in a specific order, but i don't see the wqy to do it. I imagine theres a expression to chose the order you want to display your data.

Imagine i have a list box with product lines.

Product lines:  AF, 3Q, 2Y, F4, 81 & H9

I want the list to be in the following order: 3Q, F4, H9, 81, 2Y, AF.

This is a simple example, but i need this to organize some charts and pivot tables.

HOPE SOMEONE CAN HELP!!!!!!!!!!

THANKS A LOT

         Alberto Foret Armadans

[SunilChauhan · Accepted solution]

in chart properties->sort -> expression

write this and select ascending

wildmatch(fieldname,'3Q', 'F4', 'H9', '81', '2Y', 'AF')

hope this help

[CELAMBARASAN]

Hi,

     Use the below expression in the Sort by expression option of the product lines dimension.

     =match([Product Lines],'3Q', 'F4', 'H9', '81', '2Y', 'AF')

Celambarasan

[jagan]

Hi,

Try using the expression

Put the expression in Chart Properties->Sort -> Expression

and select "Ascending"

=MixMatch(ProductLines, '3Q', 'F4', 'H9', '81', '2Y', 'AF')

Hope this helps you.

Regards,

Jagan.