Remove Grand total of Rows but not columns

[AnthonyTilley]

Hi all,

been struggling over this one for a while and cannot find a solution.

i have a matrix displaing financial information (Profit and Loss)

The Matrix is split by headers in the rows, Months across the columns 

Example below

My issue is that the Total row at the bottom of the table displays the final net profit as a negative of the true Net profit 

i alter the values within each row header to reflect a report view of the figures instead of the values need for the calculation.

this has lead to some confusion as users read the total line instead of the net profit line and draw the wrong conclusions. unfortunatly i cant fix people

is there away to remove this total line, in my other tables i simply set grand totals to white text on white back ground to remove the line 

however in this table i cannot do this as i still need the grand total in the right hand colunm to display the year total.

Any thoughts?

[Icey]

Hi @AnthonyTilley ,

Have you tried this?

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AnthonyTilley]

Unfortunatly i cannot remove subtotals as these are still needed for the idividual levels within the table when the table is expanded to the second level.

[Icey · Accepted solution]

Hi @AnthonyTilley ,

What about this?

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.