Pivot Table: Show Description instead Name
 

Hello,

I am using a PivotTable control (Excel.PivotTable). Do you know if
PivotTable control has a property to show the attributes' description and
dimension's Description in the cube instead its Name in the Field List
window???

I hope somebody can help me.

Thank you

Pivot Table: Show Description instead Name
 

Hi Daniel,

Try something like:

'=============
Public Sub Tester()
With Range("A1")
.NumberFormat = "#,##0.00"
.Value = .Value
End With
End Sub
'<<=============


---
Regards,
Norman



"Daniel Deaquino" <Daniel wrote in
message ...
Hello,

I am using a PivotTable control (Excel.PivotTable). Do you know if
PivotTable control has a property to show the attributes' description and
dimension's Description in the cube instead its Name in the Field List
window???

I hope somebody can help me.

Thank you

Pivot Table: Show Description instead Name
 

Hi Daniel,

Please ignore my response, which was intended as the
reply to another thread!



---
Regards,
Norman

Pivot Table: Show Description instead Name
 

Hello Norman,

The text that is displayed in the cells is right. That I need is to change
the Names that are displayed in the tree in "Field List" window. In this way
the user who generate the report would have names friendlier.

Thanks for answer :)

"Norman Jones" wrote:

Hi Daniel,

Try something like:

'=============
Public Sub Tester()
With Range("A1")
.NumberFormat = "#,##0.00"
.Value = .Value
End With
End Sub
'<<=============


---
Regards,
Norman



"Daniel Deaquino" <Daniel wrote in
message ...
Hello,

I am using a PivotTable control (Excel.PivotTable). Do you know if
PivotTable control has a property to show the attributes' description and
dimension's Description in the cube instead its Name in the Field List
window???

I hope somebody can help me.

Thank you

Pivot Table: Show Description instead Name
 

Hi Daniel,

Please forgive me - my reply was intended as a response to the
chronologically adjacent thread: 'Text currency to number'!


---
Regards,
Norman


"Daniel Deaquino" wrote in
message ...
Hello Norman,

The text that is displayed in the cells is right. That I need is to change
the Names that are displayed in the tree in "Field List" window. In this
way
the user who generate the report would have names friendlier.

Thanks for answer :)