Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, i Have a question about sorting data shown in pivot table.
I have data like this:
Color No.
Red 1
Blue 2
Green 3
The data sorted by Color name (alphabet) by default, now i want to sort the data by "No." field.
Do you have any idea ?
Thanks in advance.
A pivot table is always sorted first after the first dimension, then the second dimension, like wise.
Promote your Number dimension above the color dimension.
Hi,
Try like this
LOAD
Dual(ColorName, Match(ColorName, 'Red', 'Blue', 'Green')) AS ColorName,
'
'
'
FROM DataSource;
Now in Sort tab select Numeric Value
Hope this helps you.
Regards,
jagan.
go to the sort tab promote the number dimension or demote the color dimension.then select Number dimesion and in right panel select the checkbox numeric asscending
Hi ,
If you want the Same sort as you loaded means you can go with Load Order in Pivot Table Sort for each dimension.
Else ,
You can write like this in your sort expression for Color,
=IF(PIck(Match(No,'1','2','3'),'1','2','3'),No)
Hope this Helps,
Hirish
Hi,
As per your question u want the data to be sorted according to the 'No.' field..
you can simply go to chart properties ->Sort->in the dimension column just removing all sort of sorting that is pre applied and click on No. field and sort it the way u want it i.e ascending or descending..
Hope that will help you !!
Thanks & Regards,
Saniya
No. field should be the first field in the Pivot table.
Dear Lejours88,
Kindly find attached App, I hope you are looking for that one.
Kind regards,
Ishfaque Ahmed
HI Lejours,
Please find the attachment . I think it will help to proceed further .