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

[HirisH_V7]

Hi ,

I think if you want to see only dimension means , we can go for List box or else if we are having more than one expression then we can hide the particular expression . so that we  can see values of other expressions with respect to the dimension.

Hope this helps,

Regards,

Hirish

[sacosta5]

Hello....

You can´t hide an expression in a pivote table, but you can try replace it. Maybe it's helpful:

[Chanty4u]

Nice idea...but  that empty cells are displyng na......user doesn't need that empty cells also.

[rajeshforqlikvi]

Better convert pivot to straight table other wise you need to use Ad hoc reporting

[jagan]

Hi,

It is not possible to hide the expression, if you hide the expression the chart will be empty.  You can place a Text object over the column.

Regards,

jagan.

[Chanty4u]

thnx jagan..