Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hello....
You can´t hide an expression in a pivote table, but you can try replace it. Maybe it's helpful:
Nice idea...but that empty cells are displyng na......user doesn't need that empty cells also.
Better convert pivot to straight table other wise you need to use Ad hoc reporting
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.
thnx jagan..