🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

How to exclude column on Grand Total?

Bryan 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
Is possible to do this in the current version? or only in the 2.7-beta 2?

3 answers

Ian Sadovy 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?

Bryan February 19, 2019

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

Ian Sadovy Ian Sadovy Flexmonster February 19, 2019

Unfortunately, there is no such feature.

Please login or Register to Submit Answer