Please create a sample template file manually in MS Excel containing your desired pivot table, save the file and post it here. Also, give us your output Excel file (generated by Aspose.Cells) and paste the sample code here. We will check it soon.
After evaluating your issue, we could not create the pivot table using MS Excel (Pivot Table options/settings) according to "Expect". Please let us know if you could do it and post the file if he could create the pivot table only using MS Excel manually. Please attached screen shots in MS Excel to mention the steps involved. If MS Excel could do it, we will check it out asap. Otherwise, we cannot support it.