Hi,
I'm trying to create a custom group/category (w/o using the "group" feature) in an OLAP Pivot table that has the ability to show the associated group's detail. I have tried Calculated Members and Fields created using MDX but the resulting group/category doesn't show any detail. The two screen shots show the detail, the Calculated Member, and what I'm trying to achieve.
I have spent a long time researching but haven't found a solution. So maybe it's not possible or I'm not using the correct terminology in my searches.
If anyone can point me in the correct direction I'd really appreciate it!
Thanks!
A
I'm trying to create a custom group/category (w/o using the "group" feature) in an OLAP Pivot table that has the ability to show the associated group's detail. I have tried Calculated Members and Fields created using MDX but the resulting group/category doesn't show any detail. The two screen shots show the detail, the Calculated Member, and what I'm trying to achieve.
I have spent a long time researching but haven't found a solution. So maybe it's not possible or I'm not using the correct terminology in my searches.
If anyone can point me in the correct direction I'd really appreciate it!
Thanks!
A