Conditional Formatting on Grand Totals

Hamza Shakeel

Hi guys,

I am trying to hide a grand total column using conditional formatting. Currently there is no such feature available.

Is there any workaround? I want to change the background color of the grand total for some columns in my pivot table analysis.

Regards,

Farrukh

Robert Angel

One possible workaround is to create your grand totals using a union query, then they are just normal rows and you can do whatever you can do to normal rows....

Gianni Ceresa

What Robert said is "the" only possible workaround.

Grand totals are quite simple: they are either always there or never there, you can't do anything on a give one. It's really binary: all or none.

So as Robert said: create your own totals, they will be normal columns/rows.

Robert Angel

I would never be so bold as to say 'The' only possible workaround, 'time does make fools of us all' ;-)

Hamza Shakeel

Thanks guys

I found another way to do it. I used another measure in the pivot and removed totals from it.

Gianni Ceresa

For the record I better address a misleading part of my previous reply

"The" only solution is: creating the totals by hand

Not mandatory by a union query. So, as Farrukh did, also works because it's all about how the view is done in the end. Sometime a union is required, other cases works fine with an extra measure.

PS: @984465 it isn't for you but more to avoid to have to "pay the price" of my statement above for the coming years

Robert Angel

Let he who is without material mis-statement cast the first stone...