Tabular Layout for pivot table

Aspose.Cells Product Family
1

Hi team,

Which methods are useful to set the different Layouts(like compact,outline and tabular) for Pivot table.

Thanks,
Kumar.

2

Hi,


Well, to set the layout of the fields in outline or tabular form, please use the following method for PivotField.
setShowInOutlineForm:
public void setShowInOutlineForm(boolean value)
Indicates whether layout this field in outline form on the Pivot Table view.

To set in compact form, see the following method of PivotField.
setShowCompact:
public void setShowCompact(boolean value)

You may loop through your desired fields and specify the layouts accordingly.

Thank you.


3

Hi Team,

Thanks for your quick response.

for tabular form which method i used.


Thanks,
eistechnologies.

4

Hi Team,

we are using aspose 7.1.0.3 version.
we are facing some issues in setting layout options.
subtotals and report layout.

we did not find any method to set
1.show all subtotals at bottom of group.
2.tabular form as report layout.

thanks,
eis technologies.

5
ran9866637830:
Hi Team,

we are using aspose 7.1.0.3 version.
we are facing some issues in setting layout options.
subtotals and report layout.

we did not find any method to set
1.show all subtotals at bottom of group.
2.tabular form as report layout.

thanks,
eis technologies.
Hi,

Thanks for your posting and using Aspose.Cells.

1 - Please use pivotField.setShowSubtotalAtTop(false) to show all subtotals at the bottom of group.

2 - To get tabular form as report layout, please try pivotField.setShowSubtotalAtTop(false)

Let us know your feedback.
6

Hi,


1) To show all subtotals at bottom of group, please use:
pivotField.setShowSubtotalAtTop(false)

2) Please try:
pivotField.setShowInOutlineForm(false)
7

Hi Team,

Thanks for your response. issue resolved.


Thanks,
kumar.