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

[former_member231695]

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

[kohesco]

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