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
-
sweety1
-
- Posts: 539
- Joined: Wed Mar 11, 2015 1:14 am