sort on total row

[marco del frate]

Good morning, 

i would like if there is a way to sort the results on the total rows .

I'm talking about the values inside the red square in the image below.

In the sort option that i can find, there is the way to sort for the sub total but what i need , in the image above, is to see car records before bike records if i want to sort the totals from the smallest to the biggest.

Is it possibble?

Thank You inadvance

[Thirupathi Bala Krishnan]

Hi Marco,  

 

Thanks for contacting Syncfusion support. 

 

We have analyzed your reported query “if there is a way to sort the results on the total rows”. Yes, you can sort the subtotals from smallest to largest. In general, Pivot Grid will populate the data in ascending order by default with numeric string sorting. Sorting the data with your own custom comparer can be achieved by defining the custom comparer and initializing its instance to the Comparer property of the corresponding PivotItem. 

 

If you want to sort the values based on the Pivot Item (PivotRows/PivotColumns headers), Please follow the below steps in your application. 

• Define the custom ReverseOrderComparer.
• To apply this comparer to PivotItem, an instance for the ReverseOrderComparer is created and assigned it to the Comparer property of the Product PivotItem.

 

The Grouping bar should be used if you wish to sort the values based on the PivotRows/PivotColumns headers during runtime. Grouping bar allows you to perform sorting, filtering, and summarizing of data the way a user wants at runtime. Each item contains Caption, Filterbutton and Sort indicator. Sorting should be performed if the grouping bar toggle button is clicked. 

 

For more details, please refer our UG documentation from the following link: 

https://help.syncfusion.com/wpf/pivot-grid/sorting 

 

Pivot Grid control provides Excel-like sorting and filtering features applied to a pivot item. You can enable or disable the Excel-like sorting and filtering pop-up in the pivot grid by setting the AllowMultiFunctionalSortFilter property of grouping bar in the pivot grid control. 

 

If you want to sort the values based on the subtotals. Please follow the below steps in your application.  

• Define the pivot grid control and raise the loaded event for pivot grid.
• Inside the PivotGrid_Loaded() event, raise the loaded event for the grouping bar.
• Inside the GroupingBar_Loaded() event, set the value of the AllowMultiFunctionalSortFilter property to “true”.
• Click the Filter icon for the Product and select More Sort Options.
• Click Ascending (A to Z) by or Descending (A to Z) by, and then choose the field you want to sort(Quantity/Amount).

 

Please refer the following code sample. 

 

# MainWindow.xaml.cs

 

        public MainWindow() 

        { 

            InitializeComponent(); 

            this.pivotGrid1.Loaded += PivotGrid1_Loaded; 

        } 

 

        private void PivotGrid1_Loaded(object sender, RoutedEventArgs e) 

        { 

            pivotGrid1.GroupingBar.Loaded += GroupingBar_Loaded; 

        } 

 

        private void GroupingBar_Loaded(object sender, RoutedEventArgs e) 

        { 

            pivotGrid1.GroupingBar.AllowMultiFunctionalSortFilter = true; 

        }

 

 

Please refer the attached videos from the following location: 

https://www.syncfusion.com/downloads/support/forum/171189/7z/Marco-Pivotgrid1426363357 

 

Sample link: https://www.syncfusion.com/downloads/support/forum/171189/ze/SortingDemo1269976101 

 

Please let us know if you need any further assistance. 

 

Regards, 

Thirupathi B. 

[marco del frate]

Good morning,

sorry for late. This is exactly what i was seraching for.

Thank You very much

Best regards

[marco del frate]

Good evening,

i'm sorry but now there is a new problem.

The sorting works as i requested: the problem is that once i sorted on a second column, the vertical scroll bar disappear and i can't scroll nomore.

I think it's a sort of visualization bug.

i've attached a zipped gif to show you the problem

Can you help me, please?

 

Attachment: vertical_scroll_bar_1f1b848d.rar

[Thirupathi Bala Krishnan]

Hi Marco, 

Please find our response as below, 

Query	Response
This is exactly what i was seraching for.	We are glad to know that the provided solution resolved your reported scenario at your end.
The sorting works as i requested: the problem is that once i sorted on a second column, the vertical scroll bar disappear and i can't scroll nomore.	We were unable to reproduce the reported issue "Vertical scrollbar did not display after filtering the pivot rows item" on our end.  By default, horizontal and vertical scrollbars should be displayed based on the Pivot grid column and row count values. If the row count value was less than the actual pivot grid height, the vertical scrollbar was not displayed. If the row count value is more than pivot grid height, the vertical scrollbar will be enabled automatically.  Please refer to the attached videos from the following link:  https://www.syncfusion.com/downloads/support/forum/171189/7z/Marco-Pivotgrid-310959071  Sample link: https://www.syncfusion.com/downloads/support/forum/171189/ze/SortingDemo47178037  Could you please check the issue in aforementioned sample and let me know whether or not the reported issue has been resolved? If you are still experiencing the same problem, could you please share your working sample or modify the attached sample to reproduce the reported issue we can provide a solution as soon as possible?

Please let us know if you need any further assistance. 

Regards, 

Thirupathi B. 

[marco del frate]

Good moring,

i tryed Your sample and the main difference i can see is that Your Itemssource is a viewmodel class while in my caseis a table from a dataset. Anyway i removed the following option:

   ResizePivotGridToFit="True"

and now it works. The vertical scrollbar remains 

Thank You

Best regards

[Thirupathi Bala Krishnan]

Hi Marco, 

Thank you for confirming that the reported issue was resolved on your end. Please let us know if you need any further assistance on this. As always, we are happy to assist you. 

Regards, 

Thirupathi B.