cancel
Showing results for 
Search instead for 
Did you mean: 

BloX pivot with grand totals

Vlad
8 - Cloud Apps
8 - Cloud Apps

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?

5 REPLIES 5

vrice
8 - Cloud Apps
8 - Cloud Apps

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
9 - Travel Pro
9 - Travel Pro

I am looking for same solution.

If anyone has  a solution for it please let us know

Vlad
8 - Cloud Apps
8 - Cloud Apps

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

Wojtek
9 - Travel Pro
9 - Travel Pro

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.

Wojtek_0-1661164172920.png

Thanks,

Wojtek

Vlad
8 - Cloud Apps
8 - Cloud Apps

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.