We need to see the code that you have written to display the value. It may be using some aggregation, and the same aggregation is probably not being used when it has been placed on the Color Marks. As for the overlapping colors, you may need to put a dummy column with no text in both the rows and columns, and then suppress the header for them.
This is the calculation:
IF (SUM([Inventory])+SUM([Receipts] ))/SUM([Requirement]) > 1 THEN 'GREEN' ELSEIF (SUM([Inventory])+SUM([Receipts] ))/SUM([Requirement]) = 1 THEN 'BLUE' ELSE 'RED' END
(Computed along Part Number)
What do you mean by "...put a dummy column with no text in both the rows and columns..."
Something like creating a calculation with a 0 or a 1?
Well.... the dummy indeed worked, not only about the overlapping but also with the colors issues....
But now, I have another problem, some cells, where there´s no data ( Inventory = null, Requiremenst = null, Receipts = null), should be blue filled with zeroes. See the figuere below...
PS: I'm using the ZN(LOOkUP(Measure)) formula to change nulls to zeroes (this is what the blue cells represents).
Do you know how to solve it?
For null values to be shown in blue, if you do not have the option to set the colors through the color marks, you can look at using background shading at the pane level as shown below.
And for displaying zero values, pls see if you can format the calculated field and set the special values text as zero works for you.
I realize what it was..... this was caused by a dimension used as "detail", and because there was no date on those cells, the values for the dimension where null.
I removed that dimension... and now, everything is working pretty good.
Thanks for the help Hari Ankem
You are welcome.