Total and subtotal repeated in pivot table #2607

Closed Fara opened this topic on on Mar 8, 2022 - 2 comments

Fara commented on Mar 8, 2022

Hi, following is the result of my PivotTable. The subtotal and grand total numbers are repeated. The second pivot table is the expected result which is generated using excel pivot functions.

Snippet for setup and view:

I am using Koolreport Pro 5.7.1

Sebastian Morales commented on Mar 8, 2022

We can confirm this bug with Excel package version 8.5.1 or KoolReport Pro 5.7.1. Pls either update to a newer version of Excel or Pro or open the file koolreport/excel/PivotTableBuilder.php and replace the following line:

    for ($i = 0; $i < $decimals; $i++) $zeros .= "0";

with this one:

    for ($di = 0; $di < $decimals; $di++) $zeros .= "0";

Tks,

Fara commented on Mar 9, 2022

Thanks! Issue resolved.

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo

Labels

None yet

Related package Pivot

KoolReport's Forum

Total and subtotal repeated in pivot table #2607

Build Your Excellent Data Report