Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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..
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
Edit the dimension put condition according your requirement.
or on script you do same.
Regards
Ashish Srivastava
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.
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
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>
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..
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.
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.