Pivot format issue

[kk0218]

Hi there,

I am generating the Pivot report. And in the report the duplicate filed is not display, and if I want to display it how should I configure it?

I have tried several setting, still can not make it.

What I expected:

1 2 8

1 2 9

1 2 10
1 2 11

1 3 5
1 3 6
what I got:

1 2 8
9

10

11

1 3 5

6

---

[Amjad_Sahi]

Hi,

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.

Thank you.

[kk0218]

Thanks for the quick response!

Please refer the sample sheet in attachment.

[Amjad_Sahi]

Hi,

Thanks for the file.

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.

Thank you.