Hi Alessandro,
We have just answered your questions via email but there's failed email delivery. Would you please email us how to reach to you.
1/ Anyway, to fix your reloading problem when expanding some rows please open the file pivot/widgets/assets/PivotMatrix.js and replace all (there should be 3 occurences in functions expandCollapseRow, expandCollapseRowBun and expandCollapseColumn)
if (tree.children[j].name === nodes[i]) {
with this:
//use == instead of === because sometimes
//nodename like '1' is converted to 1, which causes inequality
if (tree.children[j].name == nodes[i]) {
2/ Regarding your second question, to make initial loading of PivotMatrix faster you could set “partialProcessing” = true when setting up pivot process:
->pipe(new Pivot(array(
"column"=>...,
"row"=>"...
"aggregates"=>array(
...
),
"partialProcessing" => true
)))
This option will make PivotMatrix only process and show first level headers for both row and column.
Each time you expand a header the matrix will process a little more.
Then you could compare differences between this and the default loading.
Let us know if you have any question. Thanks!