SELECT NON EMPTY CrossJoin(Hierarchize
(DrilldownMember
 (DrilldownMember
  (DrilldownMember
   (DrilldownMember
     (DrilldownMember
      (CrossJoin({[Contact].[Last Name].[All],[Contact].[Last Name].[Last Name].AllMembers}, 
{([Contact].[First Name].[All],[Contact].[Middle Name].[All],[Contact].[Age].[All],[Contact].[Email1].[All],
[Contact].[Mobile Phone].[All])}), [Contact].[Last Name].[Last Name].AllMembers, [Contact].[First Name]), 
[Contact].[First Name].[First Name].AllMembers, [Contact].[Middle Name]), 
[Contact].[Middle Name].[Middle Name].AllMembers, [Contact].[Age]), [Contact].[Age].[Age].AllMembers, 
[Contact].[Email1]), [Contact].[Email1].[Email1].AllMembers, [Contact].[Mobile Phone])), 
{[Measures].[Cheque Item Count],[Measures].[Sum Cheque]}) 

DIMENSION PROPERTIES PARENT_UNIQUE_NAME,HIERARCHY_UNIQUE_NAME ON COLUMNS  

FROM [Model] 

WHERE ([Date].[Calendar].[Year].&[2020].&[4 квартал].&[Ноябрь].&[1 Ноя 2020],
[Contact].[Gender Russian].[All],[Contact].[Send email].[All],[Contact].[Send SMS].[All],
[Product SubGroup].[Name].[All]) CELL PROPERTIES VALUE, FORMAT_STRING, LANGUAGE, 
BACK_COLOR, FORE_COLOR, FONT_FLAGS

CrossJoin(
   {
      [Contact].[Last Name].[All],
      [Contact].[Last Name].[Last Name].AllMembers
   }, 

[Contact].[Last Name].[Last Name].AllMembers