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.

Mon May 20, 2013 12:28 pm

could you please let me know how to sort pivot table column fields

chaitanya
 
Posts: 12
Joined: Thu May 16, 2013 10:42 am

Tue May 21, 2013 10:34 am

Dear chaitanya,

Thanks for your inquiry.
I provide you a full demo. Please try it.
If there is any issue, please feel free to contact us.

Regards,
Amy
E-iceblue support team
Attachments
SALESSUPPORT-1487.zip
(13.63 KiB) Downloaded 396 times
User avatar

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

Thu May 23, 2013 9:30 am

Hello,

Is the demo provided by Amy helpful for you? Has the issue been resolved? Could you please update the thread if convenience.

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

Sincerely,
Gary
E-iceblue support team
User avatar

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

Tue May 28, 2013 11:57 am

Thanks amy..the issue is resolved.
could you please let me know how to set subtotaltop(pivotfields) to true

chaitanya
 
Posts: 12
Joined: Thu May 16, 2013 10:42 am

Wed May 29, 2013 3:58 am

Dear chaitanya,

Thanks for your feedback and inquiry again.
The default value of subtotalTop property of PivotField is true. So you only need to ensure that your PivotTable has at least two fields in Row area. I provide you a demo as a reference.

There is any issue, please feel free to contact us.

Regards,
Amy
E-iceblue support team
Attachments
SubTotalTop.zip
(55.56 KiB) Downloaded 348 times
User avatar

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

Return to Spire.XLS