OWC 10 - PivotTables: Surpressing values in tool-tips

[Tony Bull]

So, I like this handy trick where you can display member properties anywhere
you like. For instance, the following piece of code will put the value of
"Bill To Address" in the tool tip which the user will see on scroll-over:

<VBScript>

With pivotTable.ActiveView.FieldSets("Customer").Fields("Customer Name")
.MemberProperties("Bill To Address").DisplayIn =
c.plDisplayPropertyInScreenTip
.MemberProperties("Bill To Address").Caption = ""
End With

</VBScript>

The only problem is, I don't like that the PivotTable renders the value of
"Customer" in the tool tip too, like this:

John Smith (Customer)
1020 Main Rd.
Smithville, WA 98302

Is there any way to surpress the output of 'John Smith (Customer)'?

Thanks!

Tony B.