title: How to Merging two groups in one category in microstrategy
body: <p>Currently I have report like:</p>
  
  <pre><code>Dept      Sub-Dept      No.Of-Lectures
  1           101            2
  1           102            3
  1           104            1
  2           201            3
  2           203            4
  </code></pre>
  
  <p>I assume in future <code>Dept 2</code> is going to merge into <code>Dept 1</code> so that <code>Sub Dept 201</code> will report into <code>Sub 102</code>.</p>
  
  <p>How can I implement this kind of requirement in MicroStrategy?</p>