Hide an Expression in Pivot table

[Anonymous]

Hello!

I have  two expressions in pivot table. I am using the first expression(name) to derive the second expression...Thus, I have to enable it..

I just want to hide it and leave only  the 2nd expression to show that depends on the on the 1st expression.

I tried using a conditional false()... it worked but the 2nd expression got affected.  This table will be sent out to our customers and it's not good for for them to see 2 expressions in 1 dimension when they don't need the 1st.   If it's not possible to hide an expression in the pivot table as stated in the community, how can I at least delete the 1st expression during Nprinting.

Pls. advice.

Rgds

[sacosta5]

Hi...

try disable the first expression.

[Anonymous]

Have you tried creating a variable made of the first expression and using that same variable in the calculation for the second expression?

[Anonymous]

Hi!  Silvia,

I already tried to uncheck the enable to no avail... this will affect my 2nd expression.

Thanks for your time.

[Anonymous]

A dodgy frig you could try :

• Set the expression Display Options | Representation to Image
• <Tick> Hide Text When Image Missing
• Make the column as narrow as possible

Ain't got a clue what NPrinting will make of this though.

[Anonymous]

Adding on to what Bill said, you could change the font color of the 1st expression to the same color as the background.  Make the expression label one character ( a space bar ) and then make the column narrow.

I have done this several times to hide a column and I typically can get the column to be only a couple characters wide.

As for sending the chart to NPrinting.  If you are sending an Image, this works great.  I do this frequently.  If you are recreating your pivot table in an Excel template in Nprinting, I have not tried that.

Hope that is Helpful

[jduenyas]

Super nice trick!!!

Only set the label to a one empty string (space) or the whole formula will show in the header row.

Alternatively you can set the color of the Label text to the color of the background to make it "disappear"

[Anonymous]

Hi!  Mike,

I already hide the text  by  the text color  and narrowed the 1st column...But it results 2 vertical lines...IF I uncheck the vertical expressions cell borders in the style, all vertical lines are gone which I don't want.

Thanks for your time...

[Anonymous]

Two lines is what I get as well.  I know it is not the optimal solution, but maybe you could shade the background of the hidden expression column to a shade that offers some contrast between your real expression columns.  Just change your text font to the same color and it will be hidden.  Almost as if you intended for there to be separation there.

Are you exporting images or data to Nprinting?

You marked your own answer as Helpful.   Please mark mine Helpful if this has had any value for you.

[Anonymous]

Hi!  Mike,

I'm exporting data in Nprinting and email externally.  That's why, I'm trying to get rid of the 1st column since it's no use to the report....This would be an issue if the recipient is trying to sum the the number for a no of weeks...The 1st column will be included on the 1st column...

Since hiding 1st column is quite impossible in Pivot table...My last hope is  to paste as values when exporting data to nprinting and delete the first column...not sure iff macro is needed here.

Tks.