Display field that have no data

[#1]

Hi All,

I have one field. But not all field got value. How can I display the field in dimension of pivot/straight table.

I want to show the fields even though there is no data on it.

Thanks.

[swuehl]

Could you post some sample records and the result you want to achieve in your chart table?

I assume the field does not show a value in all records, so you have some NULL in your data.

Maybe test for NULL in your load script and set the value of these records:

LOAD

     If(Len(Trim(FIELD)), FIELD, 'Dummy') as FIELD,

     ...