Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Showing alias for PivotFields
Hello,
I've got a problem and I'm not sure if it can be handled at all. I receive data from a database and load them into an Excel-file. There macro actualizes all PivotTables and PivotCharts in the file. My problem is that one chart presents data from different locations and these locations are shown on the X-Axis as 'City, Country' (an example would be Paris, France). I just need the City of the location ('Paris, France' - 'Paris'). Is there a way to display alias-names in the PivotTable? The original format cannot be changed because I can not change the external database. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PivotTable - PivotFields VBA | Excel Discussion (Misc queries) | |||
PivotFields problem | Excel Programming | |||
PivotFields | Excel Programming | |||
Combining 2 Pivotfields to 1(Help!!!) | Excel Programming | |||
Pivotfields.CurrentPage | Excel Programming |