Sum

[gautik92]

I have a product List in that i have sub category

if i have sum(sales) for that sub category its showing values for -

but i don have sub cat name as - in the products

if i take sub cat in list box - is not showing but if i take sum(sales) its showing sales for -

[#2]

the '-' represents null values. In your data model, you must have values for Actual that don't have a corresponding SubCatName (null)

[settu_periasamy]

Hi,

Generally Null value won't dispaly in the ListBox.. 

In your chart, Suppress the Null value in your Dimension..

[jagan]

Hi,

That - is a null value, null value is not displayed in the List object.  If you want to display some value for try like below

LOAD

*,

If(Len(Trim(FieldName)) = 0, 'NA', FieldName) AS FieldNameNew

FROM DataSource;

Now in place of null values it will display NA.

Regards,

jagan.