Subtotals only on specific Columns/Rows

Subtotals only on specific Columns/Rows

Posted by: martin.schmeling on 4 February 2026, 10:51 am EST

• 

  martin.schmeling

  • Post Options:
  • Link
    Copy

  Posted 4 February 2026, 10:51 am EST

  In the C1FlexGridPivot I activated subtotals on Rows and Columns.
  
  For Example I habe grouped by Country, Region and City, but I only want to have subtotals on Countries, but not on Regions.

  I havent´t found any chance to deactivate a specific subtotal. So I decided to find it and setting the Row of Region Subtotals to visible=false. But unfortunately, I habe a collapse-Button left on the region, that allows me to click and then the complete region-line disappears.
  
  So it also doesn´t seem to be my reason.

  So, how can I disable specific levels subtotals?

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 5 February 2026, 7:05 am EST

  Hello Martin,

  Thank you for reaching out to Mescius Support.
  
  We can observe the same behavior on our end and investigate further to see if we can develop a workaround for this use case.

  We will get back to you soon on this.

  Regards,
  
  Prabhat Sharma.

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 6 February 2026, 6:10 am EST

  Hello Martin,

  In C1FlexGridPivot, subtotals are designed to apply to all fields. Manually setting the Visible property to false for the rows you don’t need is indeed the correct approach.

  To fix the issue where rows disappear when clicking the collapse button, you can set the CollapsibleSubtotals property of the FlexPivotGrid to False. This hides the expand/collapse button, allowing your custom visibility settings to work correctly.

  FlexPivotPage1.FlexPivotGrid.CollapsibleSubtotals = False

  We have also attached a sample project FlexPivotSingleSubtotalVB__2_.zip implementing this behavior for your reference. Please have a look at it, and if you continue to face any issues, feel free to reach out.

  Regards,
  
  Prabhat Sharma.
  
  FlexPivotSingleSubtotalVB__2_.zip