Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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.
Thanks
Im using a Pivot table, is this still possible to hide?
No it is not possible with Pivot table..Shift to straight table and use it.
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
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.