How to exclude column on Grand Total?

Resolved

I want to exclude a column of the Grand Total Sum. For example, I have a column(months), in the result of Grand Total I need sum all months except december, Without specifying the months to sum

SUM(January, February, March, …) => NO
SUM(*, except december) => YES
https://jsfiddle.net/bryannsi/4Ljw6qnk/1/
Is possible to do this in the current version? or only in the 2.7-beta 2?

3 answers

Public
Ian Sadovy Flexmonster February 19, 2019

Hello Bryan,
 
Thank you for the question.
You can exclude the December column using the filter in the current version as well.
As a result, Grand Total value will be without December.
Please take a look at the following sample: https://jsfiddle.net/flexmonster/6agfsm39/
 
Does it work for you?
 
Regards,
Ian

Public
Bryan February 19, 2019

Thanks for the reply.
Is it possible to exclude only for the SUM, keeping the column visible?

Public
Ian Sadovy Flexmonster February 19, 2019

Unfortunately, there is no such feature.

Please login or Register to Submit Answer