Show only total in straight table

[#1]

Hello everyone,

I'm trying to create monthly bonus report. Is there a way to show only total value in column 2 (Net Fixed Payroll), which is Net Fixed Payroll for Month in column 1 of some salesperson. I also want to sum total value from column 2 and column 7 and show it in column 8

like in the picture below.

I attach excel table like a example.

Any help means a lot. Thanks

[PrashantSangle]

Hi,

I am not sure about your 2 requirement but you can achieve your first requirement by,

Go to Chart Properties->Expression->select your expression->Total Mode->select Expression Total or (Sum) of Rows.

and select No Totals for those expression which you don't need to show total,

Regards,

[#3]

Thanks max for your answer, but I need something else.

I want to show only total value of column 2 and other cell to have blank.

And in column 8 I need to sum total from column 2 and column 7 like in the picture or Excel.

Thanks

[maxgro · Accepted solution]

in a straight table  to hide text

click on + on the expression you want to hide and for text color use expression (adapt to your need)

if(Dimensionality()=1,argb(0,0,0,0), black())

example Sales EUR

[maxgro]

column(2) + column(7)

[#6]

Thanks, it's perfect