Skip to Content
avatar image
Former Member

How to filter the values based on comparison with other columns(Dimensions)

Feb 28, 2018 at 05:43 PM | 64 Views | Last edit Feb 28, 2018 at 05:48 PM 3 rev.

Hi Experts,

I am facing issue in webi, PFB below issue.

I have a 3 columns Data, time, status as below.

DATA TIME STATUS

PO 2/13/2018 Delayed

PO 2/26/2018 Ontime

PO 2/27/2018 Ontime

Below are the conditions for the requirement:

If we have status as Delayed only for a single Data column(Ex:PO) then in the report we need show only Delayed with latest date.

If we have status as Ontime only for a single Data column(Ex:PO) then in the report we need show only Ontime with latest date.

If we have status both Delayed,Ontime for a single Data column(Ex:PO) then in the report we need show only Delayed with latest date and need to exclude ontime from the table (Need to show only one record).

Please throw some light it would really helpful to me.

Regards,

Mahesh

capture.png (6.1 kB)
SAP BusinessObjects - Web Intelligence (WebI)
SAP BusinessObjects Business Intelligence platform | SAP BusinessObjects - Web Intelligence - SDK | webi | webintelligence | webi reports
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Ivan Yin
    Mar 02, 2018 at 02:46 AM

    This is not a very smart workaround for your requirement. Just try to add a new column to mask the rows that need to show.

    1. Create a variable using the formula as below:.
    2. Then filter this variable with 1 and the row you expect will show

    =If Count([Status]) In ([Data]) = 2 And [Status] = "Delayed" And [Time]=Max([Time]) Where([Status] = "Delayed") Then 1 ElseIf Count([Status]) In ([Data]) = 1 And [Time]=Max([Time]) In Report Then 1 Else 0

    Add comment
    10|10000 characters needed characters exceeded