RE:How to hide?

[Chanty4u]

hi all,

I have a pivot table with  one expression....

i need to hide dat expression...and in pivot table i need to show onlt dimension....wiithout select anything?

is this possible?

thanks in advance.

suresh

[#2]

Hi,

you need to use straight table.

there is an option to hide expression...

[HirisH_V7]

Hi,

I  think we cannot hide a pivot table expression directly. Fill colour of the first expression to white, set the label to  ' ' (space) and make it as narrow as possible to make it (almost) disappear.

On the Style tab, uncheck "Vertical Expression Cell Borders" to avoid the appearance of an empty cell.

or

Make Back ground ,Font Color as white()

HTH,

Hirish

[Chanty4u]

how to show only one column  as bold.......in table box?

is it possible?

[HirisH_V7]

Hi ,

Settings -> user desgin -> Always show design menu items

Then,

on table box -> right click -> custom format cell

we can change back ground color of header and rows too for a  particular column.

HTH,

Hirish

[Chanty4u]

thnx hirish..it wrks fine... but i need frst one...pivot table issue

[HirisH_V7 · Accepted solution]

Hi,

At  the expression tab select your expression and  can check the box 'Conditional' at the right top  and use 0 as the condition that will permanently hide that expression.

PFA .

Hope this helps,

Regards,

Hirish

[Chanty4u]

yeah..hirish...

its hiding its ok..

but the other dimension values are nt shwng anythng.....?

[Chanty4u]

chk image   when use exp conditional...exprsng gng hide..but there is no data shwng...as i hve dimension vlues

[jonathandienst]

A pivot table can display without an expression to show only the dimensions (unlike a straight table). You do need to uncheck the "Suppress Zero-Values" in Chart Properties | Presentation.