Pivot Page filed Select Multiple Items

Aspose.Cells Product Family
1

HI,

Please give me sample code for select multiple items and checkbox
option in pivot table page filed option?
If i select the multiple item checkbox and field checkbox it is showing all items only but i need multiple item while the selected the field check box and need to display in the page field as multiple items


please refer the attachement also.Thanks in advance!!!!

Thanks
Shipnet

2

Hi ShipNet,

I will log your thread as related in our internal issues tracking system. CELLSNET-24140

We are already working on Pivot tables and charts and will provide the relevant features and fix the related issues by the end of this month. We will also provide you code example then.

Did you see my past reply at this thread? Thanks for your patience.

Re: Chart.NSeries[0].Type throws exception.

3
<!–[if gte mso 10]> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman","serif";}

<![endif]–><span style=“font-size: 10pt; font-family: “Microsoft YaHei”,“sans-serif”;”>Hi,

Please try the attached latest version/fix v5.2.2.4.

You can set
IsMultipleItemSelectionAllowed attribute in page field.

sample code:

workbook.Worksheets[0].PivotTables[0].PageFields[0].IsMultipleItemSelectionAllowed
= true;

workbook.Worksheets[0].PivotTables[0].PageFields[0].HideItem(0, true);

Thank you.