Is there any construction in MicroStrategy, when we can get together with grouped data not only the Total (grand or subtotal) which sums the group's totals, but also the Total which count distinct values from all the groups? (we need this "distinct" total in one report with group data)
Example:
Person 1, Group 1
Person 1, Group 2
Person 2, Group 1
When we are grouping data on attribute "Group" we get:
Group 1, Count(Person) = 2
Group 2, Count(Person) = 1


Grand Total = 3
How can we get result like this:
Group 1, Count(Person) = 2
Group 2, Count(Person) = 1
Grand Total = 3
Distinct Total = 2
?
I know one solution with "Custom groups", but it can't be used when number of "Groups" is large...
(in Oracle we can get results with construction "group by rollup").