• Try:

    With Member [Revenue Energy]

    As ([Measures].[Total Revenue], [Dimension Sector].[Sector Group].&[Energy])

    Select [Measures].[Revenue Energy]

    On columns from [EUS Fin Mart]