Forum Discussion

Sander800's avatar
Sander800
Helper I
9 years ago
Solved

Remove filter in If statement

Hi All,   Hope you can help me out with this one. I am trying to create 2 sets/ groupings of accounts which I want to show in a table in the rows. However the second set is part of the first set hi...
Need Help
Tutorial Requests
  • robofski's avatar
    robofski
    9 years ago

    How about creating two calculated columns:

     

    Total Costs = IF(PL_Blink_Cube[SCOA Level06 ID] = 4500000000, PL_Blink_Cube[Amount],BLANK())

    Some Costs = IF(PL_Blink_Cube[SCOA Level10 ID] = 64405401, PL_Blink_Cube[Amount],BLANK())

     

    This way you keep the rest of the table and have all your relationships.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Sander800,


What other dimensions do you refer to? Please post expected result here.

Regards,

Lydia

robofski's avatar
robofski
Resolver II
9 years ago

How about creating two calculated columns:

 

Total Costs = IF(PL_Blink_Cube[SCOA Level06 ID] = 4500000000, PL_Blink_Cube[Amount],BLANK())

Some Costs = IF(PL_Blink_Cube[SCOA Level10 ID] = 64405401, PL_Blink_Cube[Amount],BLANK())

 

This way you keep the rest of the table and have all your relationships.

  • Sander800's avatar
    Sander800
    Helper I
    9 years ago

    Thanks all,

     

    This really helps me in the right direction. I think this will help me solve me issue.

     

    Again thanks for the help!