How do I create calculated sets, for example for ABC groupings? Author: Tobias Eld Last updated: February 01, 2021 23:12 Note: This is an old article. However, some tips may still apply to newer versions. Please see the attached document. Calculated set support and ABC Grouping example v2.docx (40 KB) 1 Comments Date Votes 0 Tobias Eld July 25, 2012 13:17 This might be helpful if it does not work for you. You can change the order that they have in the calculate script within the two groups, but you cannot make a calculated member appear after the script commands. The only way would be to create the measure as a script command as well: CREATE MEMBER CURRENTCUBE.[Measures].[ABC Group] AS iif( IsEmpty( [Measures].[Measure for ABC] ), null, iif( Intersect( [A], [Items].[Item].CurrentMember ).Count > 0, 'A', iif( Intersect( [B], [Items].[Item].CurrentMember ).Count > 0, 'B', 'C' ) ) ), FORMAT_STRING = "#,#", VISIBLE = 1; Please sign in to leave a comment.