Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Conditional Formatting on Grand Totals
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
Answers
-
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....
0 -
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.
0 -
I would never be so bold as to say 'The' only possible workaround, 'time does make fools of us all' ;-)
0 -
Thanks guys
I found another way to do it. I used another measure in the pivot and removed totals from it.
0 -
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
0 -
Let he who is without material mis-statement cast the first stone...
0
