Something like Custom Groups in Microstrategy

[#1]

Hello,

What is my current status:

| Column1 | Column2 |

|      1       |    CAT     |

|      2       |    DOG    |

|      3       |    DOG    |

|      4       |    CAT     |

|      5       |    CAT     |

I want to add selection window witch two values: CAT and DOG.

After selecting CAT, only 1, 4 and 5 values should be selected and valid.

Is any easy way to do that?

Kind regards,

Pawel

[Nicole-Smith · Accepted solution]

Use a list box.

[#3]

Ok, and now the second scenario:

I've got only one column

| Column1 |

|      1       |

|      2       |

|      3       |

|      4       |

|      5       |

there is no other column (CAT, DOG) with releted value like it was in first scenario. But I want still to make selection window with DOG and CAT values, and after clicking on CAT, only 1, 4 and 5 values should be selected and valid.

More complex, but is any easy way to manage that?

[Nicole-Smith]

You need to link two tables together in the load script in order to get those results.

[#5]

Or I can use If statement

If(Column1 = 1, 'CAT'...) as Something

Anyway. Thanks.