Skip to Content
0

Lookup Values within Dimension

Oct 24, 2016 at 08:38 PM

15

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jyothirmayee A Nov 28, 2016 at 07:30 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded