Hi All,

I'm a bit of a newbie to pivot tables, but all was going well with GetPivotData until I tried to get data from a field that I had grouped member items into two higher-level groups. Then, instead of nice neat member names like...

[Vendor].[Tone].[Color]

I now get almost unreadable member names like...

[Vendor].[Tone].[Tone1].[GROUPMEMBER.[ToneXl_Grp_1]].[Vendor]].[Tone]].[All]]]

My question is... is there any way to create somekind of shortcut to make this long group member name something more readable?

Thanks
Ray