I want to select few fields data in a straight table

[ferha_jafri]

Hi everyone,

I have a list of matrices of a company and i want to include few of the matrices in straight table as dimension.

Thanks in advance

[sujeetsingh]

Ferha,

just use set analysis,

As for example there be Region and we want to include Region ="London"

then you can use a calculated dimension as -

only({$<Region={London}>}Region)

[narender123]

Hi Ferha,

You can simply "calculate dimention" in Dimention tab of preoperty of Straight table.

Calculate Dimention:

If(Company='a',Company)

See the attachment file.

Thanks.

Narender