CubeView not displaying literal value

[BrianMillerDL]

I have a cube view that displays values that are entered monthly. For the months that haven't had any data entered yet, it automatically fills in a 0 in a greyed-out format. Similarly, if I display this same row in a YTD view, it shows the YTD value in the months that have not been entered in yet. My customer would prefer these cells display no value. I cannot find any setting or formatting that will display it that way.

I've tried changing the number format to empty string ("") based on IsNoData or IsDerived but that has not yielded the desired result.

[Hweeli]

Hi BrianMillerDL,

Try Condition formatting:

If (IsDerivedData = True) Then
TextColor = Transparent
End If

Hwee Li