BloX pivot with grand totals

[Vlad]

I'm using the BloX transposed pivot template below:

https://support.sisense.com/kb/en/article/transposed-pivot-table-with-blox

How can I add a column on the right that shows the grand total of each value?

[vrice]

Hi Vlad,

Were you ever able to find a solution for this? I am also trying to add a grand total to a BloX pivot.

Thanks!

[Wojtek]

I am looking for same solution.

If anyone has  a solution for it please let us know

[Vlad]

I was not able to find a solution to this, it doesn't seem to be possible.

[Wojtek]

HI. I eventually did this as quick fix . will do for now.

I duplicated widget, removed row label columns leaving only values and removed entries from Items panel (in may case I removed date) so there is only single column with values. Renamed top label to 'Grand Total'. Its a separate widget next to original one and this works for me.

Thanks,

Wojtek

[Vlad]

Thanks Wojtek, that's a good workaround. I'll see if it works for me, though my layout is larger and more complex so it might cause issues with scrolling.