Sort and columns order PivotGrid

[Juan Chau]

Dear Syncfusion,
I love your Dashboard solution, easy to implement, easy to use and very user friendly!

I have few questions to to improved my dashboard presentation,

I attach a image from one dashboard, i like to sort the rows order from Highest Sum value to the lowest by default, and i can only do for the rows name.
Second,  in the months there is numbers instead of names (1, 2,3, so) meanning Octuber = 10, November = 11 and the order it not considering the value (1,2, 3, ..) also as string (1, 10, 11, 12, 2) i need to arrange the columns of the months in the value order, or if i need i can change to months name but the same how i set to make in the correct order?

Thank You Very Much!
Juan
-------------------------------
Estimado Syncfusion,
Me encanta su solucion de Dashboard, facil de implementar, facil de usar y muy amigable con el usuario!

Thengo unas preguntas para mejorar mi presentacion.

Adjunto la imagen de uno de mis dashboards, deseo ordenar las filas desde el valor mas alto de la suma hasta el menor por defecto, solo puedo ordenar por los nombres de las columnas.
Segundo, en los meses tengo numeros en lugar de nombres (1, 2, 3, y asi sucesivamente) significa Octubre = 10, Noviembre = 11 y el orden no esta considerando el valor (1, 2, 3) sino los caracteres (1, 10, 11, 12, 2) necesito ordenar las columnas de meses por su valor, o si es necesari cambiar a los nombres de los meses pero igual como los ordeno correctamente?

Muchas Gracias!
Juan

Attachment: Dashboard_f924e33c.zip

[Renuka N]

Hi Juan Chau, 

 

Query	Response
i like to sort the rows order from Highest Sum value to the lowest by default, and i can only do for the rows name.	Currently, we do not have support for value based sorting in PivotGrid. We have already logged the feature report for the requirement of value based sorting in PivotGrid and it will be implemented in any of our release.
Second,  in the months there is numbers instead of names (1, 2,3, so) meanning Octuber = 10, November = 11 and the order it not considering the value (1,2, 3, ..) also as string (1, 10, 11, 12, 2) i need to arrange the columns of the months in the value order, or if i need i can change to months name but the same how i set to make in the correct order?	Instead of giving month number (1,2,3,..)as a string column, you can bind a date field to PivotGrid and change its format to “Month”. Now PivotGrid shows value in month order(Jan,Feb,…).  Please refer the following steps to achieve your requirement.    1.       Add fields to Values and a date field to Rows/Columns.      2.       Click the settings icon, choose “Month” in the menu item.      3.       Now, PivotGrid shows value in Month order.

 

Regards, 

Renuka N