Grouping with subtotals

[Florin]

Hello ,

I want to create a groups with subtotal functions ..and i need a little example ( for using subtotals).

Thanks a lot!

Florin

[Administrator]

Hi Florin, I herewith attach a Sample for Subtotal functions. SubtotalFunction_2383.zip Please see to the Sample and let me know if you have further questions. Best Regards, Seetha >Hello , > >I want to create a groups with subtotal functions ..and i need a little example ( for using subtotals). > >Thanks a lot! > >Florin

[Florin]

Hello Seetha,

Thanks for your quick response. I see your example ... I alredy used SUBTOTAL FUNCTION. My problem is .. to make same similar like Data subtotals from Excel menu. I want to obtain subtotal and grand total values in a list and outlines the list so that I can display and hide the detail rows for each subtotal.

Thanks a lot.
Florin

[Administrator]

Hi Florin, Here with i attach a Sample for Grouping with subtotals SubTotal_9780.zip Please let me know if you have further questions. Best Regards, Seetha >Hello Seetha, > >Thanks for your quick response. I see your example ... I alredy used SUBTOTAL FUNCTION. My problem is .. to make same similar like Data subtotals from Excel menu. I want to obtain subtotal and grand total values in a list and outlines the list so that I can display and hide the detail rows for each subtotal. > > >Thanks a lot. >Florin >

[m.vishwanathan]

Hi could not download the above samples .I am facing some difficulty with the sub totals.Guess these samples could be useful.Can some one repost the sample for grouping and subtotal!!!!

[Jawahar Jeevanandan J]

Hi Vishwanathan,

Thank you very much for using the syncfusion products.

That sample has been posted long ago, so we could not able to download it. We have created the new sample for grouping and subtotals. We can group the column or row by the group method available in the range class. The following code snippet also explains the same.

Code snippet(C#):

sheet.Range["B2:J2"].Group(ExcelGroupBy.ByColumns);
sheet.Range["B2:J2"].FormulaArray = "{10,20,30,5,15,35,6,16,36}";
sheet.Range["K2"].Formula = "SUBTOTAL(A2,B2:J2)";

I have also attached the sample for the same along with this update. Please try this sample at your side and let us know if this helps you.

Please let us know if you have any clarifications.

Thanks,
Jawahar.



Sample_a9c461bf.zip