How to add pivotItem to pivotItems and pivotItems to pivotfield

Aspose.Cells Product Family
1

Hi Aspose,

1) We are using a pivoted excel template which has empty pivoted Items. We want to dynamically add pivoted items. Can we do this using Aspose Cells Java?

2) We created pivoted sheet using Aspose which looks good. Is it possible to reorder the Pivoted Item, we need this because we want a pivoted item to be always last item in the matched filter.

Example :- In the attached file look at the CLOSED POSITIONS column to be always last in the filter(I marked in the green color)

Regards

Raj

2

Hi Raj,

Thanks for providing us the template file.

Well, I am afraid all types of manipulation to an existing pivot table is not supported. We may consider this feature and support it in the future versions.

Thank you.

3

Hi,

I think you may use "PivotField.setAutoSort(true);PivotField.setAscendSort(false);" for the "Strategy" field.