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
-
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
-
Gary.zhang
-
- Posts: 1380
- Joined: Thu Apr 04, 2013 1:30 am