Pivot Table - Custom Sub Total row whilst group expanded

Question

When a group is expanded in the pivot table the sub total information is not displayed, this is not helpful for large groups with complex data.
How do I add a sub total row to the bottom of a group as an additional row whilst it is expanded?

Also, it would be useful to know the number of children within a group to show a total of the rows within this new sub total row.

Ideally, it would also be displayed on the group header whilst collapsed.

Screenshots attached of what I am trying to achieve.

Thanks in advance.

Saranya Sivan · Accepted Answer

Hi Lee Stevens, 
  
Thanks for contacting Syncfusion support. 
  
Please find the response below,   
 




Query 

Response 


When a group is expanded in the pivot table the sub total information is not displayed, this is not helpful for large groups with complex data. 

As per the current behavior of the pivot table the sub totals of children rows will be displayed in its parent row which is placed at the top of its children. Please refer the below screen-shot for more information. 
 
Sample Link: https://www.syncfusion.com/downloads/support/directtrac/general/7z/BlazorExample742184506 
  
Screen-shot: 
  
  
 
So, kindly reproduce the reported problem in the above sample and revert us (or) send us your sample which would be helpful for us to proceed further. 


How do I add a sub total row to the bottom of a group as an additional row whilst it is expanded? 

We regret you to let you know that adding custom rows in the pivot table couldn’t be achievable.  


It would be useful to know the number of children within a group to show a total of the rows within this new sub-total row.  
Ideally, it would also be displayed on the group header whilst collapsed. 

We regret you to let you know that the requirement couldn’t be achievable in the pivot table because the child information won’t be available when its parent is in collapsed state. 
 
    
Please let us know if you have concerns. 
  
Regards, 
Saranya Sivan.

Query	Response
When a group is expanded in the pivot table the sub total information is not displayed, this is not helpful for large groups with complex data.	As per the current behavior of the pivot table the sub totals of children rows will be displayed in its parent row which is placed at the top of its children. Please refer the below screen-shot for more information. Sample Link: https://www.syncfusion.com/downloads/support/directtrac/general/7z/BlazorExample742184506 Screen-shot: So, kindly reproduce the reported problem in the above sample and revert us (or) send us your sample which would be helpful for us to proceed further.
How do I add a sub total row to the bottom of a group as an additional row whilst it is expanded?	We regret you to let you know that adding custom rows in the pivot table couldn’t be achievable.
It would be useful to know the number of children within a group to show a total of the rows within this new sub-total row. Ideally, it would also be displayed on the group header whilst collapsed.	We regret you to let you know that the requirement couldn’t be achievable in the pivot table because the child information won’t be available when its parent is in collapsed state.