Skip to Content

Removing the rows from webi with null values

Hello,

I have a webi report with several hundred rows, some of the rows have null/blank value and i want to remove those rows from the report, I only want to show the rows which have numbers.

What would be the variable or formula syntax i can use to remove the rows from webi report which are blank with no values.

Will appreciate the help

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 15, 2017 at 10:40 AM

    right click on the table->Format table->uncheck "Show rows with empty measure values" and check the checkbox "hide when empty"

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 16, 2017 at 06:13 PM

    Hi,

    Yes, you can suppress rows and columns with null values in Analysis for Office Excel.

    Select query properties and you should see check box that shows to Suppress

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded