Katams,
Try this query. Only thing you need to do is format the totals to show it as the others.
With member [Store].[Total] as 'Sum({[store].members }) '
Select {[Measures].[Sales Count], [Measures].[Store Sales]} ON COLUMNS, non empty {[Store].[Total], Descendants([Store],[Store].[Store...
When we use the following in our MDX query our sorting does not work as intended. The dates are not sorted correctly, in fact it seems to random.
Set [OrderSet] as 'Order( {[NonEmptyRowsSet] },[ClientJob].currentmember.properties("Open Date") ,BASC )'
The open date member property...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.