Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Wed Jan 22, 2014 4:28 pm

Hi, Is possible in pivot two or more column in HearCaption ??
Exemple:
Column A1 "rep"
Column B1 "client"
Column c1 "Other::

and subtotal in bottom not in top ??
Thanks

ict@sogedin.it
 
Posts: 63
Joined: Mon Jul 15, 2013 2:06 pm

Thu Jan 23, 2014 8:01 am

Dear Gianpietro,

Thanks for your inquiry again.
For the first question, sorry that I don't understand it well. Is the below code what you want? If not, would you please provide us a sample to help us better understand it? Thank you.

Code: Select all
       PivotField r1 = pt.PivotFields["rep"] as PivotField;
            r1.Axis = AxisTypes.Column;

            PivotField r2 = pt.PivotFields["client"] as PivotField;
            r2.Axis = AxisTypes.Column;

For the second question, please get the solution from the last post of the link (set-subtotals-for-a-pivot-table-in-spire-xls-7-2-t4630.html).

Have a good day.

Best wishes,
Amy
E-iceblue support team
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Tue Jan 28, 2014 9:34 am

Dear Gianpietro,

Has your issue been resolved? Could you please give us some feedback if convenience?

If there are any questions, welcome to get it back to us.

Thanks,
Gary
E-iceblue support team
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Return to Spire.XLS