Forums Home / ComponentOne / WinForms Edition
Posted by: nitin on 21 February 2021, 6:51 pm EST
nitin
Posted 21 February 2021, 6:51 pm EST
Hi,
I am using C1FlexPivot in WinForms
I have inserted multiple Row Fields and I want to add Subtotal for a specific field. When I enable the GRID> Total Rows > Subtotal then it adds subtotal for all Row Fields. But I want to add for one field only.
Also, is there any possibility to add one menu in the context menu of the Field? I want to add “Insert Subtotal” menu. After clicking on it, only for that field subtotal will be inserted.
avnish.kumar
Posted 22 February 2021, 10:13 pm EST
Hi Nitin,
We have answered the query on your support case with ID [CAS-19837-S3N8M4].
Please continue there.
Regards.
Avnish
nitin
Posted 4 June 2021, 3:21 am EST - Updated 3 October 2022, 2:10 pm EST
Dear Sir,
I have seen the sample code but that is not at all as per the requirement.
When I enable the GRID> Total Rows > Subtotal then it adds subtotal for all Fields in the columns. Which creates a very chaotic view.
We want to add the Subtotals to the selected Columns only. This selection can be from Drop down menu from toolbar.
Please check the attached Image. Like in the image, I want to see the Subtotal for Models only. And not for the other columns.
avnish.kumar
Posted 6 June 2021, 6:22 pm EST
Hi Nitin,
You can hide the extra subtotals row from the FlexPivotGrid by setting the Visible property of the specific row to false. Please refer to the sample attached and modify it according to your requirements.
Regards.
Avnish
FlexPivotSingleSubtotalVB.zip[img]https://gccontent.blob.core.windows.net/forum-uploads/file-8b2a2af3-5c6d-49ed-8f4a-ed8b1aa075bd.gif[/img]
nitin
Posted 6 June 2021, 9:38 pm EST
The Code is working fine but need to finetune further.
I think I can do it.
Thank you.
