Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to do a conditional formatting on a Pivot Table where one of the dimensions is the Months. I'd like to have the past months to be in bold font. Somehow, it's partly doing it with this:
if(Month(EffectiveDate) < Month(Today()), '<b>'))
It works partly because in some selections, some (yes, just some) of the past months is not showing as bold. Not sure what I'm missing.
Please help! I'm a newbie!
no difference. still the same.
and if you add 2 expressions
max(Month(EffectiveDate))
Month(Today())
what do you get for Mar, Apr?
10 and 11 for March and April, respectively.
Attached is an example of what I'm trying to do. the 'C' should be bold based on the conditional formatting I gave but since Q1 is zero for C, the Dimension is not showing bold.
You can have zeros instead of nulls, it seams like this solves the problem (see attached)
It works. Thank you. However, some of my Pivot Tables turn to all zeros after I un-select the 'Suppress Zero-Values'. I'll research on that next. Let me know if you know the answer to that as well.
Thank you.
Is there another way of accomplishing this. I have fields that are all zeros and I want to hide them.
I couldn't find a nice way to do it, but what you can do is add another expression that populates the cells with 'ones' only for the first value/row (in case its always the same or you can calculate it someway)
See attachment