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
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.
- Create a variable using the formula as below:.
- 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