Pivot table for a specific case in java

amitkumartrips · October 25, 2017, 9:26am

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.

amjad.sahi · October 25, 2017, 1:24pm

@amitkumartrips,

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.

amitkumartrips · October 27, 2017, 8:46am

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.

Amit

amjad.sahi · October 27, 2017, 10:13am

@amitkumartrips,

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.