Is there a way I can get the value of the column when I have no data for that cell?
Why?
Because you are using a matrix when you apply fill to the cell it applies to the whole column unless you specifically write the expression to do otherwise.
Is there a way I can get the value of the column when I have no data for that cell?
If the cell has no data then the value will be Nothing, ie =IsNothing(Fields!Sales.Value) will yield true
You can use this in the Fill expression if, for example, you wanted the background to white if no value.
Far away is close at hand in the images of elsewhere.
Anon.