asked on February 18, 2019
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?
⋅ 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
⋅ February 19, 2019
Thanks for the reply.
Is it possible to exclude only for the SUM, keeping the column visible?
⋅ February 19, 2019
Unfortunately, there is no such feature.
