Avoid Zero's in design studio Charts

[former_member204452]

Hi Community,

  How to avoid zero's in design studio charts.

In my database some fields having value as zero, i don't want zero cell in chart display.

below is the current output.

Thanks,

shant

[Karol-K]

Hi,

what is your data base? is this report created on top of a BW query? Perhaps you can give also the screenshot of the corresponding crosstab for the data.

In that case, you can activate "zero suppression" in query designer tool - then the result set will not bring up values with "zero" in it.

see Query Properties -> Rows/Columns ->

Karol

[former_member204452]

thanks ,

report has been created based on HANA services, please can u give some ideas based on that.

[Karol-K]

oh, this is different.

It is not possible to set such property in design studio, you have to check if it is possible in Analytical View or Calculation View on HANA Studio level.