Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to create simple chart with Dimention Year with expression sum(sales)
i am getting one extra field with "_" after all the years in X axis.
i am not getting why i am getting it and how to avoid it. Can anyone helpme to resolve.
Regards,
Sandeep
The reason is that In your model there are sales not associated to any year, the - you see means null values, in your chart in the dimension tab check the "suppress when value is null" box, you shoult even take a look to your model (How's that there are sales without year?)
Through Diemsion tab i have acheived it. but i am still confused. Can you explain more what i have to do in data model
hi,
try this hope it will help you
this is because you not suppressing the null value
check the suppress when value is Null
Hi Sandeep
In your data model, there might be products that have never been sold or customers that might have not placed any orders.
All the above cases give us a Null value in the Facts table as a foreign key (since there is not existing Order to associate with them). This null is not associated with any year, so it appears as a separate value in your chart. That's why you see this extra value.
You can suppress it by following the above instructions.
I hope this clarifies the situation.
Regards
Agis
send me the image of your data model