Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
After moving one dimension to horizontal axis in pivot table, vertical dimensions background color change is not working any more.
If I move the dimension back to vertical position coloring is working well.
I have the following code in Background color:
=If(ELEMENT_UPDATED > Today()-30 ,RGB(255, 255, 0))
Any idea what is wrong with this one?
BR, Outi
Perhaps it could be because you don't have aggregation on ELEMENT_UPDATED and pultiple value for your dimensions. Can you try to add max(ELEMENT_UPDATED ) or mode(ELEMENT_UPDATED ) ?
Share example with us could be great too.
Thanks,
I tried both but they didn't help.
Any other things in mind that I can try?
BR, Outi
Hi,
finally I get back to this issue.
Here is an example. The only difference between those two tables is that I have dragged Area dimension on horizontal axis.
In
In Pivot Table 1 the colors are as they shoud be.
Any ideas?
BR, Outi
It's because they have missing values in the first column of the expression (Area1). Unfortunately this leaves the background color blank
Do you know any workaround for this?
Unfortunately no, unless you introduce a bogus 0 value or similar for the missing values in the first column
Thanks for you help, I will try that