Showing extra bar in bar chart

[prajapatiamar38]

Hi Experts,

I have one application in that i have made a cyclic group dimension and according to that i want to show the total sale.

But it is showing one extra bar in bar chart but in my dimension table of office country there is only three countries

but it is showing one extra.

I don't want to show that.So how can i do this.

Plz find the attached qvw and help me.

Thanks

[arulsettu]

in preoperties dimensions tab check supress null values

[arulsettu · Accepted solution]

[prajapatiamar38]

Thanks its working.

[avinashelite]

please find the attachment for the solution, you just need to do the suppress null in the dimension