Hi Rafa,

To push the grand total row to the end of PivotTable-Bun template, please open the file pivot/PivotUtil.php, go to line:

$this->sort($rowIndexes2, $rowSortInfo);

and insert these right after it:

$grandTotalIndex = array_shift($rowIndexes2);
array_push($rowIndexes2, $grandTotalIndex);

On the other issue, to hide certain plus or minus icons, please add the following css rule to your page:

    [data-row-field="0"] > .fa {
      display: none;
    }

Depending on your data-row-field, this will hide the first level icons (row-field=0) or the second level icons (row-field=1), etc.

Let us know if these methods work for you. Thanks!

Hi Rafa,

Didn't the edit of code push the Total row to the end of page? What do you mean by "my opening balance before "total"? Do you care to provide screenshot to specifically describe what you want. Thanks!

Hi Rafa,

Both PivotTable and PivotMatrix have "rowSort" and "columnSort" properties. In your case, perhaps this could be useful:

        PivotTable::create(array(
            ...
            'rowSort' => array(
              'balanceField' => function($a, $b) {
                if ($a === "SALDO INICIAL") return -1;
                if ($b === "SALDO INICIAL") return 1;
                return strcmp($a, $b);
              },
            ),
            ...
        ));

You might want to change "balanceField" to the field that your balance belongs to and experiment with swapping -1, 1 in the above code to see its effect. Thanks!