Greetings from E-iceblue!
Glad to inform you that we just released Spire.XLS Pack(Hotfix) Version:11.9.2 which supports moving the "Values" field to row labels, please download it from the following links to test on your side with the code below. Looking forward to your test result.
Website link: https://www.e-iceblue.com/Download/down ... t-now.html
Nuget link: https://www.nuget.org/packages/Spire.XLS/11.9.2
- Code: Select all
pivottable.ShowDataFieldInRow = true;
pivottable.CalculateData();
Sincerely,
Brian
E-iceblue support team