largeselection
Active Member
- Joined
- Aug 4, 2008
- Messages
- 358
Hello,
Is it possible to create a named set in MDX with OLAP data that contains a subtotal?
So if I have a field now called "ID" and I know that some of the IDs are in group 1 and some are in group 2, I know I can create a named set to just show group 1 - it would involve the visualtotals function and then I would just select all those members in group 1. That works great to show just that group, but is it possible to have the named set show group 1 subtotal, members of group 1, then group 2 subtotal, members of group 2, then a true grand total?
TIA
Is it possible to create a named set in MDX with OLAP data that contains a subtotal?
So if I have a field now called "ID" and I know that some of the IDs are in group 1 and some are in group 2, I know I can create a named set to just show group 1 - it would involve the visualtotals function and then I would just select all those members in group 1. That works great to show just that group, but is it possible to have the named set show group 1 subtotal, members of group 1, then group 2 subtotal, members of group 2, then a true grand total?
TIA
