making the Detachment invisible

[#1]

hi

i am using an pivot table to show the data.. the issue i am having is when i select a value the rest of the values gets hidden.. i know i can right click and select Detach but in the heading i can see that.. is there any way i could hide this??

plz can some one help me out in this would really appreciate it

thank you

[jsingh71]

you want to hide your pivot table or heading only??

[jagan]

Hi,

Try like this

Chart Properties -> Caption - > Uncheck Show Caption -> and use Text Object as the header.

or use text object and place the text object on top of the table caption.

Hope it helps you.

Regards,

Jagan.

[#4]

when you reload dose the detached tables become unattached ??

[#5]

isn't there any other way to fix those values?? without using the detachment ??

[tresesco]

Genearl tab -> Read Only ?

[jagan]

Hi,

Try Read Only in Chart Properties -> Geneal tab

or try in expression sum({1} MeasureName), if you want to show all values irrespective of selections.

Regards,

Jagan.