| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 :) |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pivot Table: Show Description instead Name
Hi Daniel,
Please ignore my response, which was intended as the reply to another thread! --- Regards, Norman |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to show description for an OLAP attribute in a pivot table? | Excel Discussion (Misc queries) | |||
| Adding columns in Pivot Table having coomon description | Excel Worksheet Functions | |||
| Adding columns in Pivot Table having common description | Excel Worksheet Functions | |||
| Show values only in a pivot table | Excel Programming | |||
| show only > 9 in a pivot table | Excel Worksheet Functions | |||
Hybrid Mode
