How to Remove blank cells based on Measure

[former_member203111]

Hi Webi Gurus,

We have AR Aging analysis report built in webi based on BEx query.

Our Aging brackets (measures) are 0-30, 31-60, 61-90, 91-120 and 120+

We are using structure based on BEx query which has invoices, Reason codes, Deductions etc.

If I run the webi report and drag in invoice or customer, there are so many blank rows and the report looks empty/blank and the user has to scroll down to see it plus it is really annoying to see so many pages with no data.

How can I get rid of blank cell/rows based on key figures if there is no data for aging, 0-30, 31-60, 61-90, 91-120 and 120+ brackets

Note that I am using structure from BEx along with these aging measures 0-30, 31-60, 61-90, 91-120 and 120+

Please advise if there is any feature in the tool or if I can write and logic.

Will really appreciate the help.

Thanks

[amitrathi239]

can you share the data screenshot?

[former_member203111]

Thanks, it is resolved by changing the backend BEx structure.

[sven_oehme]

Hi,

have you tried to use the table properties under format table?

Grtz

Sven

[former_member203111]

Yes and that doesnt work thats why I posed this question. I assume it is becuase of BEx structure being used in the report, Any thoughts ?

Thanks

[sven_oehme]

OK. The behavoir of structures is often different.

And if you trie to use a hard filter on a condition like

if (ISNULL(Sum(<measure>)) = 1) then 1 else 0?

Grtz