Hi community members,
I have created a barchart with Year field as dimension and sales as expression, but the dimesnion is showing only two values, actually I am having a total 8 values in the field,anyone of you help me out
Do you have any sales data associated with the other 6 years that are not displayed?
If not, they will by default be suppressed from the rendered chart but this can be changed under the Properties > Presentation > Suppress zero values
I have unchecked the supress zero values, still I am unable to see all the years
I didn't check the mail, sorry for that. For this, use like this,
Year as Dimension
If(Sum(Sales) > 0, Sum(Sales), 0) as Expression
if you didn't get means,select show all values in dimension tab..
From this, you can get the requirement..
Thanks Ramsamy,I got it, I have posted sample date range file ,please check it and reply me
Can you provide as correct or helpful answer if you got the requirement means, that helps other to find the solution for the related answer
I am unable to get the data related to other years,eventhough their is data related to that years, can you tell me where is the problem
Use tablebox and choose the field as you want and check whether there is the data or not for that years. or
simple see in the table viewer..
Hope that helps
Retrieving data ...