Returning a value based on another value

[former_member763929]

Below is a sample of data I have:

I want the report to show the most current Request Status (in bold) for each Account # like this:

I have created variables that return the most recent Status Date and to return the current Sequence # but cant figure out how to link that Request Status to either to get rid of #MULTIVALUE.

Thanks!

[former_member763929]

Thank you for visiting SAP Community to get answers to your questions. Since this is your first question, I recommend that you familiarize yourself with Community Q&A , as the overview provides tips for preparing questions that draw responses from our members.

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your Profile you encourage readers to respond.

[ayman_salem]

Define the following variable:

v_status: = "1" Where ([Sequence #] = Max([Sequence #]) In ([Account #]))

then filter the table with "v_status is not null"

...

I hope it helps

[bphiggi]

This is close, but not quite. There report has other information in it and when I create the above variable and add it to the report, it shows the correct Request Status, but a bunch of the variables change to #MULTIVALUE

[ayman_salem]

So it seems that other variables are having problems with filters in general.

So try to change these variables "causing #MULTIVALUE" or use NoFiter() function in them.