ordre in pivot table

[#1]

Hi,

i want to show data in  a specific order, so that in my inlines i add a order column for exemple:

LOAD * INLINE [

    CODE_CATEGORIE41, COMPTE EXPLOITATION, ORDRE_CE

    71100, Ventes de Marchandises en état, 1

    71101, Ventes de Marchandises en état, 1

    71102, Ventes , 2

    71103, Ventes , 2

    71104, CA, 3

    71105, CA, 3

];

and in my sort expression i try this:

=Match(ORDRE_CE,'1','2','3)

and this

=ORDRE_CE

but in both situations it inverse the two last order, it gives me

Ventes de Marchandises en état

CA

Ventes

can anybody tell me why i have this issue

thank you

[Chanty4u]

LOAD * INLINE [

    CODE_CATEGORIE41, COMPTE EXPLOITATION, ORDRE_CE

    71100, Ventes de Marchandises en état, 1

    71101, Ventes de Marchandises en état, 1

    71102, Ventes , 2

    71103, Ventes , 2

    71104, CA, 3

    71105, CA, 3

];

where ORDRE_CE ascending;

[sunny_talwar · Accepted solution]

Is it doing this after you make a selection or even without selection? If it happens only after making a selection, try this;

=Only({1} ORDRE_CE)

[#4]

thank you for answer, it happens without making selection.

i tried Only({1} ORDRE_CE) and it works could tell me what only and {1} means

[MayilVahanan]

Hi

{1} - Ignore all the selection

ORDRE_CE and only(ORDRE_CE) both are same.

we can use set analysis Only() function, not by field name alone.

So, Only({1}ORDRE_CE) avoid selection made by user. And display the order properly

[sunny_talwar]

MAYIL got before me, but yes the idea is to tell the sort to ignore any selections because it may filter out some of the options based on certain selections you make.

[#7]

thank you all for your answres