Pivot table for a specific case in java

image.png (14.5 KB)

Can you send me code how to create attached pivote table? We are trying to drag first field to row and rest 2 to data and it always generates following pivot table and chart:

image.png (36.5 KB)

Please review.


Thanks for the screenshots.

Could you provide us your output Excel file by Aspose.Cells APIs and your expected Excel file (containing your desired PivotTable and chart), you may create your desired PivotTable/chart manually in MS Excel. Also share the sample JAVA program (runnable) that you are using with Aspose.Cells APIs, we will check it and help you through.

Hi Amjad,

I got it working using tables and dropped idea of using pivot table. I will try to get in touch with you again if I need something.

Thanks for your help.



Good to know that you have sorted it out. Feel free to contact us any time if you have queries or issue, we will be happy to assist you soon.