How to have multiple grand totals in a cross table or remove a secondary cell value axis while keeping the grand total from it

[J Gre]

Hi,

I have a cross table that shows expenses with a grand total by column. I would like to add a secondary grand total that shows a precentage. I've tried ading a secpndary cell value for the percentage which works but I am unable to hide those added columns while keeping the second grand total.

I have attached an image of my table. I would like it to look like it is now but without the 'percentage' columns while keeping the 'grand total of precentage'.

Thanks,