Skip to Content
avatar image
Former Member

Lookup Values within Dimension

Hi Everyone,

I have a merged table from two reports of different universe. The merged table contains Case Number, Week Number (Dynamic Variable) and Status columns.


Case Number column:
Case 1
Case 1
Case 1
Case 2
Case 2
Case 2
Case 3
Case 3
Case 3

Week Number (number keeps on changing per week)column:
43
42
41
BLANK
42
41
43
42
41

Status column:
None
Good
Good
Not Good
Good
Not Good
Good
Good
Good

The output I want to get on separate table is :
Case Number column:
Case 1
Case 2
Case 3

Var_Week Number column:
43
BLANK
43


Var_Status column:
None
Not Good
Good


Tried this formula on Var_Status column but not displaying anything:
=[Status]Where([Week Number]=[Week Number of Current Week]) Where(IsNull([Week Number]))

I'm using BO4.1 Version 14.1.

Any help is appreciated. Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 28, 2016 at 07:30 PM

    Hi,

    This is month old post and not sure if you are still looking for a solution.

    If not, what happens if you pull in all 3 columns into the report after the merge?.

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded