Hi folks,
I import data from third party APIs that have the data in a weird format where all the metrics are in columns and all the dimensions are in rows. Anyhow, I have to use the pivot tables. Sometimes.
I'm trying to give them the layout of the rest of the document and I believe I did what I needed well enough except one thing. Here's my pivot table:
4AwCch.jpg
http://imagizer.imageshack.com/img923/7582/4AwCch.jpg
Now, the question is how to make ONLY the two cells that have "Grand Total" to have white font color? You see, my first row and first columns are set to be white, but the total rows are set to be black. So the latter overrides the former and I need to reverse it. Can I?
Bookmarks