Using Values in Expression

[#1]

Hello everyone:

I have a measure created in expression called 'SalesAmount' using set analysis,

currently I am using this Label of SalesAmount in the formula of another

expression.

My problem is that when I disable the SalesAmount measure (so as to not to

show in the table)  the formula where I am using the label of the SalesAmont

also gets disabled, is there any way around this.

Appreciate any help on this issue.  

[#2]

Store the expression in variable and use it insted of reading the label text.

[#3]

Hi,

If you use a straight table, you should go to properties -> "Presentation" sheet, select the expression (Columns)  and check the "Hide Column" option.

Pivot table doesn't have the hide column option.

Regards,

Ricardo

[#4]

Hello Mr. Baeyens:

Thanks for your reply and time, I tried using the variable but have an

issue,

the value passed out of the variable expression is lumped out like sample

below.

(The Part & Region Dimensions used in the Pivot table are dynamic)

Part Region Sales vSalesFrom Expr

A Canada $10 $30

B US $10 $30

C US $10 $30

Appreciate any help in the above.

[#5]

Hi Ricardo:

Thanks for your reply, but need to use a pivot table

Thanks

Kumar