Completely disable totals calculations in PivotGrid + performance

From a starting point:

USA     Pizza     1000

USA     Donut     200

Canada     Donut     30

Mexico     Pizza     300

move Food to "columns" and see

               Food

USA     1000     200

Canada     blank     30

Mexico     300     blank

I was able to do this using CalculationType =NoCalculation and setting all ShowTotals = false, ShowSubtotals =false and so on.

Still, it is kind of slow when I do that action (about 5 seconds in a high end pc and with just a few data elements), because I guess that although subtotals and totals are not shown, they're still being silently calculated. Is it possible to completely deactivate total and subtotals calculation in order to make the control a little faster?

Also, my datasource will NEVER have more than one value for a given combination of values for the dimensions. In the example above, Country+Food would be a composite primary key. I'm not sure if that precondition could allow me to tune the PivotGrid control in any way to make it faster.

I'm with the WPF version of the control but I could switch to Winforms if you think the that version might be more performant.

Thanks in advance!

Hi Carlos, 

Thanks for contacting Syncfusion support. 

We have checked your requirement “Display flat data without subtotals in PivotGrid control” in your working version 16.1.0.37. As per the default behavior of PivotGrid, sub-totals for underlying data source will be calculated automatically while populating the values in PivotEngine. Only the subtotals will be ignored from displaying when the grid cells are prepared to render and display. Hence it is necessary to calculate the subtotal to achieve the pivot functionality.  

However we have checked the same in our machine to ensure the performance of our control and we could not see that any performance issue as per your update. We have attached our working sample. Could you please share us your machine configuration where did you get performance issues along with the kind of operation should be performed? 

Sample link: http://www.syncfusion.com/downloads/support/forum/142814/ze/PivotGridDemo-1382614567  

 

Please get back to us if you need any further assistance on this. 

Regards, 

Arulraj A 

Hi Carlos, 

Thanks for the update. 

We have analyzed your requirement – “Data values are not displayed while drag and drop the fields from row to column”. As per default behavior of pivot grid, only the grand total row is displayed while moving the entire rows into columns. In your application, you  had set the ShowGrandTotal property value as false. Since the data values have not displayed. If you need to display the last row data values, you should enable the ShowGrandTotals property value as true in your application. 

Please refer the following code sample: 

Please let us know if you need any further assistance. 

Regards, 

Thirupathi B.