Flip BW Query

Hello community,

I hava a problem concerning the sturcture of data. Is there a way to do the following scenario.

I receive data like this:

ID

TYPE_ID

BOOLEAN

STRING

INT

10

CATEGORY1

YES

10

CATEGORY2

YES

10

NAME

JOHND

10

RANK

1

and the data should be displayed in the Query like this:

ID

CATEGORY1

CATEGORY2

STRING

INT

10

YES

YES

JOHND

1

Is there a way to do so?

For a selection I would need a keyfigure. This would work in case of int. I would create a selection like this:

TYPE_ID = CATEGORY1

Keyfigue = INT

But in case of boolean it would not work since this is not a keyfigure but a 'NUMC'.

Is there a way to solve this ?

Thank you in advance.

Andreas