Showing results for 
Search instead for 
Did you mean: 

Characteristic in row should show all the values

Former Member
0 Kudos

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


Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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.