Skip to Content

BO Webi need to show only one row acc. to Maximum ID

Dear BO experts,

In my Webi report, Material, Promotion key, Promotion sales start and sales end are all dimensions, I want to show only one row which the Promotion key is the Maximum, in this case only show the row which Promotion key is 2000002863.

How can I achieve this requirement?

Million thanks!

Regards,

Galland

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 09 at 03:53 PM

    Hi

    create 2 variables:

    1. MAX =Max([Promotion Key]) In ([Material]) ->Measure
    2. FLAG_MAX =If [Promotion Key]=[MAX] Then 1 Else 0 ->Measure

    add those 2 variables to your resulttable

    Filter on FLAG_MAX=1

    You should have the max-lines only

    you can set the 2 variables as hidden in your resulttable

    Add comment
    10|10000 characters needed characters exceeded