sorting the pivot column fields

Technical support for Spire.XLS

Moderators: iceblue support, Flash, Manager

sorting the pivot column fields

Postby chaitanya » 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

Re: sorting the pivot column fields

Postby amy.zhao » 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 92 times
User avatar
amy.zhao
 
Posts: 2251
Joined: Wed Jun 27, 2012 8:50 am

Re: sorting the pivot column fields

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

Re: sorting the pivot column fields

Postby chaitanya » 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

Re: sorting the pivot column fields

Postby amy.zhao » 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 86 times
User avatar
amy.zhao
 
Posts: 2251
Joined: Wed Jun 27, 2012 8:50 am


Return to Spire.XLS

Who is online

Users browsing this forum: No registered users and 1 guest

cron