Selecting from straight table

[#1]

Hi!

I am using a straight table and there are 7 dimensions.

let's say the table has column name as project Name

and its values are project 1, project 2 ,....project 7..

I want to have one straight table that only shows project 1,2,3,4

and another straight table that shows 5,6,7

dimension limit won't work because the expression result for each project is not ordered high to low or low to high from project 1 to project 7...

is there any way to seperate this out???

Thank you!

[johnw]

You could either replace null with 'NULL' in script, or I think you could do this in the script:

NULLASVALUE Group;

I've never done it. I'm not sure how the null values would actually look with that approach. I'd probably just do the replace if I could.

[#3]

Thank you John for your kind explanation and reminding me about the inline functionality