List a pivot table's field names vertically

Hi,

I am curious if it is possible to list the column field names next to the respective rows with the column field values, rather than on top of the rows with the column field values.

I’ve uploaded two prints to illustrate what I mean.

In the original_table I’ve selected “Item Type” and “Manufacturer” as column fields, and they are listed on top of the rows containing their items/members. However, in the desired_table I’ve they’re listed next to the rows.

I am not sure if this is even possible in Excel, but is it possible with Aspose.Cells?

Kind regards,

Daniel

Hi,


Thanks for providing us screen shots and some details.

Could you provide us your sample JAVA program with template files (input (if you have) + output file), we will check it soon. Also provide an Excel with your desired PivotTable report, you may create your expected PivotTable in MS Excel manually. This will help us to evaluate your requirements and issue precisely and we may provide you sample code or suggest you to update your existing sample code accordingly.

Thank you.

Hi,

Thank you for your reply.

I don’t really have any code that illustrates what I want to make. However, I’ve uploaded a workbook that has a pivot table I manage to create with Excel and a copy of that pivot table, but where the “Item Type” and “Manufacturer” header is next to “Ball” and “Asis” rather than above “Ball” and “Shoe” as in the actual pivot table. I am wondering if something like that is possible to do with a pivot table?

Alternatively we’ll write code to copy the contents of a pivot table and do it manually (by moving cell contents so it matches the desired look).

Kind regards,

Daniel

Hi,


Thanks for the template file with your desired output.

I have evaluated your scenario/ case and tried to create your desired PivotTable manually in MS Excel but could not create your exact desired PivotTable. So, I think using PivotTable feature, it might not be possible and we cannot mimic your complete desired results with pasting custom labels at your desired positions for the Pivot Table, etc. even in MS Excel. If something is not possible in MS Excel (for PivotTable feature) manually, it cannot be implemented by Aspose.Cells Pivot Table related APIs. So, you may go for manually creating your desired formatted report via Aspose.Cells APIs.

Thank you.