Conditional Formatting on Grand Totals

Question

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 · Answer

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

Gianni Ceresa · Answer

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

Hamza Shakeel · Answer

Thanks guys

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