Skip to Content
author's profile photo Former Member
Former Member

Workbooks - Using Maximum, Minimum etc in the results

Posted on May 21, 2004 at 02:26 PM 16 Views

Hello,

Within BW workbooks, you have the option to choose..

Calculate -> Results as.. -> maximum (or minimum, average etc).

However, the Totals row still has "Results" written on it, which can be confusing for the end users. Does anyone know of any way to indicate that a Maximum or Average etc is being displayed on the Totals?

Thanks,

Allan

BW Business Explorer (SAP BEx)
Add comment
10|10000 characters needed characters exceeded

1 Answer

  • author's profile photo Marc Bernard
    Marc Bernard
    Posted on Jun 08, 2004 at 04:24 AM

    Hello Allan,

    in BW workbooks you could create a VBA macro that does a search and replace. On web queries you can use the table interface to replace the "Results" text (see HOW TO … HIDE A COLUMN IN YOUR WEB QUERY WITH THE TABLE INTERFACE).

    Regards,

    Marc

    SAP NW RIG US BI

    Add comment
    10|10000 characters needed characters exceeded