Is it possible to hide expressions?

[#1]

I need to hide an expression from being published, but as its linked to formula it still needs to form a basis for the report.

Un-checking the' Enable' button in the expressions tab removes it from the report completly , all I want to do is hide it & for formula still to be calculated from data in this expression.

Is this possible ? 

[jagannalla]

Yes it is possible.. may i know which object you are using.

For eg:

With straight table we can hide expression using calculations.

Presentaion Tab -> select your expression -> Click on Condition radio button and give u r calculation.

[#3]

Thanks

Im using a Pivot table, is this still possible to hide?

[jagannalla]

No it is not possible with Pivot table..Shift to straight table and use it.

[Sokkorn]

Hi

I think this one is not available yet in Pivot Tables. But we still can do it with these solution:

1. Use a text color Dimensions to make the text same color as backgound.

2. Macro:

     SUB HideDimension

        SET ch = ActiveDocument.GetSheetObject("CH01")

        ch.SetPixWidth 0, 0

     END SUB

Hope this help.

Regards,

Sokkorn

[Anonymous]

I am not sure if you can use this but I sometimes set the calculations in the hidden script, like:

     LET v_Profit     = 'SUM(SALES) - SUM(COSTS)'

Then you can use :          $(v_Profit)        as your expression.

Hope it is helpfull.

Dennis.