Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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.
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
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
Dear,
if you want to sort by your choice then create a Inline table.
kindly find the attached document.
Thanks,
Mukram.
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