Sorting Help????

[amit_saini]

Hi Folks,

I'm having Pivot table as below:

Is there any possibility of sorting order according to your choice .Please see below i want Un Bold labels to come in this order:

Thanks,

AS

[lironbaram]

hi

if i understand the image

sum of the fields are vertical dimensions label , and some are values in a horizontal dimension

if this is the case as far as i know you can't order them as you want, those are diffrent types of columns

[satishkurra · Accepted solution]

Hi

Please find the below example.

Hi

Please follow the below order of script for CUSTOM SORT.

Temp:

LOAD * Inline [

Category

Meat

Fish

Chicken

];

Data:

LOAD * INLINE [

Category,Sales

Fish,100

Meat,200

Chicken,450

];

DROP Table Temp;

Note:

Reload the script. Modify the properties of the Category list box and on the Sort tab,

set the Sort by option to Load Order.

[amit_saini]

Liron,

All these labels are under one calculated Dimension named as Downtime-Cat-Desc. Instead of vertical view i made them as Horizontal view. I just want to change order of these labels , if possible in the same view as mentioned in First image.

For example after Downtime-Cat-Desc. , I want to see first Maschinenstorung  instead of Anfahren\Abfahren as first view if possible , vertical view should remain the same.

Only order will change after Downtime-Cat-Desc as below :

Thanks,

AS

[lironbaram]

if this is the case then yes

you could load an inline table

somthing like :

Downtime-Cat-Desc, sortorder

fiedvalue     ,1

fieldvalue,2

that holds the sort number for each value

and in the sort tab you sort by expression and in the expression you write

= sortorder

[mdmukramali]

Dear,

if you want to sort by your choice then create a Inline table.

kindly find the attached document.

Thanks,

Mukram.

[SunilChauhan]

use in sort expression

wildmatch(fieldname,'value1yowwant','Valu2youwant','value3youwant',........)

you can as many as ValueNyou want in above expression

and try ascending or descending as you want

hope this helps