Skip to Content

How to Remove blank cells based on Measure

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 15, 2017 at 06:21 AM

    Hi,

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

    Grtz

    Sven

    Add comment
    10|10000 characters needed characters exceeded