We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Sort and columns order PivotGrid

Thread ID:

Created:

Updated:

Platform:

Replies:

129674 Mar 27,2017 09:21 PM UTC Mar 28,2017 12:06 PM UTC Dashboard Platform 1
loading
Tags: Dashboard Widgets
Juan Chau
Asked On March 27, 2017 09:21 PM UTC

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 [Syncfusion]
Replied On March 28, 2017 12:06 PM UTC

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 
 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;