Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: cltalbott3
- Order by date
-
Running Totals
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...- cltalbott3
- Post #4
- Forum: ODBC/OLAP
-
Sorting on a member property that is a date
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...- cltalbott3
- Thread
- Replies: 0
- Forum: ODBC/OLAP
