Limit values in Dimension

[#1]

Hello,

I'm creating a straight table. with a dimension. in this dimension, we have A, B , C, D.

How can i limit the dimension to only show B & C?

Thanks.

[#2]

Hi,

I don't why do you want to use Straight table instead of Pivot table /chart when you have such criteria to follow.

Still, if you want in straight table, easier /simpler way will be create separate list box of dimension A,,B,C,D.

Choose whicheve dimension want in Straight table.

Happy Thoughts

[#3]

Edit the dimension put condition according your requirement.

or on script you do same.

Regards

Ashish Srivastava

[#4]

Hi Ravi

pivot table and straight table in my instance doesn't really help, because i still need to find a way to limit the value.

i tried script i tried condition, none of them work, if you have a script pattern in mind on how to limit, it'd be great if you could share?

Thanks.

[#5]

Ok,

In that case, use pivot table.

Use "Name" A,B,C,D as Dimensions and apply condition for that dimension as follows:

IF(Name='B' or Name='C',Name,Null())

Also, tick on "Suppress Null values" in Dimensions.

Let me know if this serves the purpose.

Happy Thoughts

[#6]

Hi nick,

Try something like:

[test]:
Load
Dimension
From database.xls (biff, embedded labels, table is Sheet1$)
where Dimension <> 'A' and Dimension <> 'D';

- Lester
 </body>

[#7 · Accepted solution]

Hi Lester,

Nice option, it works, but i didn't want to affect my data.

So, my workaround is, in the straight table, in expression, use set analysis to limit the value you want to calculate, and it will remove the unwanted value for u.

Viola..

[#8]

hi Nick,

If i follow your idea of handling from expression, all i see is one row for both dimension values (hear A and D) instead of two diffrent rows. Please correct me if i miss something..  ex:

Name     Value

A               1000

D               2000  

Tx. 

[#9]

hi Nick,

If i follow your idea of handling from expression, all i see is one row for both dimension values (hear A and D) instead of two diffrent rows. Please correct me if i miss something..  ex:

Name     Value

A               1000

D               2000  

Tx.