Need help in Subtotals

Sep 20, 2011 at 11:28 PM

I am very new to EPPlus. Just i want to know how to do the Subtotals function in EPPlus.

Date              Name       Earnings

9/19/2011       A             10

9/20/2011       A             20

9/21/2011      A              30

9/19/2011      B              25

9/21/2011      B              50

I want results like

 

Date              Name       Earnings

9/19/2011       A             10

9/20/2011       A             20

9/21/2011      A              30

                    A Total       60

9/19/2011      B              25

9/21/2011      B              50

                     B              75

and if possible i need Grand Total for all Earnings.

 

Thanks,

Kartook

Coordinator
Sep 27, 2011 at 3:42 PM

Have a look at sample 6.