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
Bookmarks