Hi,I have a pivot2 table and some trouble calculating the correct Totals, due to many-to-many joins. However, I can tweak the data model, so that either the values OR the Total is correct, and can even display that in the same pivot2 table.Hiding one of the columns should be possible according to this post: https://community.sisense.com/t5/build-analytics/pivot-2-0-hiding-columns-from-the-display/m-p/3607So now I just need a way to overwrite the Total calculation of my column "correct value...

Hey Martha , Please refer to sample Pivot widget script. the Script store the grand total(Cell.content) of the First Value column, (Index 1 in the example) and replace it with the Grand total of Index 2. Please modify the script as needed. const myTarget = { type: ['grandtotal'] }; let grand_total = null; // widget.transformPivot(myTarget, function(metadata, cell) { if (metadata.colIndex === 1) { grand_total = cell.content; // Store the grand total value of column index 1 }...

Replacing Total with different column in Pivot2 | Help and How-To

MoreDiscussions

Replacing Total with different column in Pivot2 | Help and How-To | Sisense Community