Skip to Content
Former Member
May 03, 2009 at 08:16 AM

Characteristic in row should show all the values


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