Hide Total Column or Grand Total Column in Data Views

Niklas Multerer

Hi,

I’d like to hide the “Grand Total” column on a screen. The sum across multiple years doesn’t make sense. Unfortunately, I haven’t found anything so far that helps me with this. Some of my colleagues have also encountered this use case in other projects and were unable to resolve it. Can you help us? More details are shown in the picture. This mainly concerns case 5 and especially case 6. 

Robert Barkaway

Hi Niklas, I'm not sure there's a simple way to do that unfortunately, to the best of my knowledge you can only hide the Grand Total row, not the column. The only way I've dealt with that in the past is to use the Block Formatting to effectively make the Grand Total column invisible by making it white text on white background.