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
Is possible to do this in the current version? or only in the 2.7-beta 2?
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?
Thanks for the reply.
Is it possible to exclude only for the SUM, keeping the column visible?
Unfortunately, there is no such feature.