Skip to Content
0

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

Jan 07 at 09:29 AM

57

avatar image

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

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

1 Answer

Koen Hesters Jan 09 at 03:53 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded