Hiding an expression in pivot table

[triciagdaly]

When hiding an expression 'Cost' in a pivot table using  the conditional function of false(), it's removing the display of the other expression 'tons' (see result attachment)  I'm not sure how to reformat the pivot table .  The goal is to achieve the display in the first screen shot (before modification) but to remove or hide Cost column. 

[jduenyas]

Before unchecking

Unchecking

After unchecking

[Anonymous]

I assume that the Tricia's problem here that there is no label for the column "Amount" (?)

If there is only one expression, the column header is gone.

[triciagdaly]

Yes I have a label for Tons.  Puzzled why it was removed when unchecking Enable.

[triciagdaly]

Attached is the qvw.

[Anonymous]

Sending back with two changes.

- Applied colors to the dummy expression

- Ran the macro (by pressing Test in macro editor)

[Anonymous]

One more idea - in my file, go to the chart properties, tab Style, and uncheck "Vertical Expression Cell Borders".  Much cleaner look...

[kamielrajaram]

Hi Tricia,

Try this in you conditional expression. It achieves your desired result without unchecking the enable box.

if(sum(Tonnage)>=0,0,1)

[triciagdaly]

I'm new to macros.  Where did you invoke the macro?

[Anonymous]

Clicked "Test" button (on the left) in the macro editor.

[triciagdaly]

Kamiel,

Thank you.  However, This produces the same result as unchecking enable box.  Michael's suggestion is working.