How can i remove the total data bar stacked in the graph ?

[Anonymous]

I have created a bar graph as shown in the attachment which has a data total bar stacked (highlighted in black box) at the end.

Although the total column data isn't available in my input file, this bar is appearing.

I have not even checked in the box for total in Properties>>Dimensional Limits>>Options>>Show Total.

How can I get rid of this stacked bar?

[tresesco · Accepted solution]

Try enabling 'Suppress When Value Is Null' in the dimension tab.

[marcus_sommer]

This bar will vanish if you enable to hide NULL within the dimension - therefore go into the tab dimensions and enable this option for your dimension [Line Item].

- Marcus