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 Jul 06, 2015 3:45 pm

Hi,

I generating Pivot Table for a dynamic DataTable.
I need to display last column of pivot table as % of Column Total.

Do we have any property?

Thanks

pavan.gangisetty
 
Posts: 1
Joined: Mon Jul 06, 2015 1:08 pm

Tue Jul 07, 2015 9:40 am

Hello,

Thanks for your inquiry.
Sorry that our product does't support to set last column of pivot table as % of Column Total at this stage.
It currently only supports to set the datafield.
Code: Select all
pt.DataFields[1].ShowDataAs = PivotFieldFormatType.PercentageOfColumn;


Best Regards,
Sweety

E-iceblue support team
User avatar

sweety1
 
Posts: 539
Joined: Wed Mar 11, 2015 1:14 am

Return to Spire.XLS