Get Free Trial

What is the best way to hide zero or empty value rows?

Milan Dragovic asked on July 6, 2020

Also is there a way to default the report to do this form openning?

3 answers

Milan Dragovic July 6, 2020

I need to filter out highlighted lines as attached

Vera Didenko Vera Didenko Flexmonster July 6, 2020

Hello, Milan,

Thank you for writing to us. 

We kindly suggest one of the following approaches:

  1. Representing zero values as null instead of 0:

    In Flexmonster, empty rows are not shown by default.
    This means that if all zeros are represented as null, then the zero value rows will not be shown.

    Please see the following JSFiddle example for illustration:

  2. Applying a value filter: 

    Another solution is to apply a value filter to the corresponding hierarchy to filter out the zero value rows.

    Here is a JSFiddle example for illustration:
    In the example, the filter is specified in the initial slice configuration, therefore, the zero value rows will be filtered out by default. 

    For more information about configuring the slice object, please see the following guide: 

Please let us know if this works for your case. 
Looking forward to your reply.

Kind regards, 

Milan Dragovic July 15, 2020

Hi Vera, thanks for your response, will try these two approaches when I get a moment.  I’m sure it’ll be fine

Please login or Register to Submit Answer