Hi All,
How can we sort data of dimension filed as currently we can sort for measure field only.
Thanks
Han
Thanks a lot for your support.
Hi Han,
Currently there are two types of sorting in pivot grid. Value and alpha sort. Value sort is enabled by default. You can sort values in the grid with value sort indicator. This indicator is positioned only in column header as shown in attached picture. Alpha sorting is disabled by default. You can enble it when set "AllowHeaderColumnsSorting" and "AllowHeaderRowsSorting" properties. When set to true a sort indicator is shown in parent hedaer cell when mouse is over this cell (refer to the attached picture)
When a value sorting is applied, alpha sorting for rows can not be applied.
I'd to sort the value of row or column by clicking on the header. Please check the attached picture.
Do you mean you want to sort dimension header cells alphabetically ?
Regards,
Mircho Yovchev