Characteristic in row should show all the values

[Former Member]

In our requirement we need a query in which one characteristic should always display all it values.

Say Sales Group has values 1, 2 and #.

Without any restriction on Sales Group it will show all the values.

But if we restrict it by 1, it should still show 1, 2 and #.

Here only for 1, it should show values.

For 2 and # it should not show any keyfigure values, but still should be displayed as blank.

I tried Constant Selection on Sales Group. But it is not showing the correct values.

Any help on this would be great.

Appreciating your help

Subbu

[Former Member]

Create a structure

New Structure ->New elements

Restrict each row by values 1, 2 and 3. Whenever on the query 1 is selected values for 1 will populate and others will show blank, but the column will always be there.

I guess this is what you want. Let me know if you find any problem implementing it.Hope this helps.