title: Insert/replace text in SSRS report using MDX
body: <p>i am running a MDX in my DATASET in SSRS Report. The MDX is</p>
  
  <pre><code>SELECT 
    NON EMPTY 
      {[Measures].[Amount]} ON COLUMNS,
   NON EMPTY 
   (
   {
   ([Dim Account].[Account Type].&amp;[Income], [Dim Account].[Account Summary].[Account Summary])
      ,([Dim Account].[Account Type].&amp;[Income], [Dim Account].[Account Summary].[All])
      }
      )
      ON ROWS
      FROM [CubeProfitLoss];
  </code></pre>
  
  <p>After running this MDX i am getting the following result in SQL Server Result Pane</p>
  
  <p><a href="https://i.stack.imgur.com/cbVIv.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/cbVIv.png" alt="enter image description here"></a></p>
  
  <p>But when i add this MDX code in my Dataset and run the report i am getting every thing same except 'ALL' it is not shown up and i am actually i don't want to show 'ALL' instead of this i am happy to insert/replace 'TOTAL' in that place. Is anyone have that stuff? I always appreciate any king of help </p>