Skip to Content
0

Removing the rows from webi with null values

Feb 15, 2017 at 04:36 AM

329

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

AMIT KUMAR
Feb 15, 2017 at 10:40 AM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Amit, Can we do the same in OLAP Analysis for Office tool ?

0
Jyothirmayee A Feb 16, 2017 at 06:13 PM
0

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


Share
10 |10000 characters needed characters left characters exceeded