I'm working on an analysis where I have a pivot table that looks at Total Award by Institution, by year, and ranks the institutions by Total Award. The general format is:
| 2018 | 2017 |
|---|
| Institution | Total Award | Rank | Total Award | Rank |
| Cool Biscuit University | 1,000,000 | 1 | 950,000 | 2 |
| Excellent Soup College of Broth | 900,000 | 2 | 975,000 | 1 |
| Great Taste Academy | 550,000 | 3 | 600,000 | 3 |
The Rank is calculated using RANK(Fact.Total Award). I've created a calculated item to show the percent change in Total Award between the two years. I used conditional formatting so my percent change shows as a percent--that works just fine. The issue I'm having is that it's also giving me a percent change for the Rank, which I do not want. I've tried conditional formatting on Rank where if the year is Null, CSS display is none. This gets rid of the values in the percent change column for Rank, but the header is still there. And of course, if I exclude Rank, then it doesn't display in the table at all. I am using 12c.
Is there a way to do conditional formatting on the headings in a table? Anyone have any tips?
Thanks in advance!