title: Trying to Add Sub Row Group inside Parent but flush left in the nested cell
body: <p>What I am trying to do:</p>
  
  <p>I am trying to create nested groups but I want the sub row group to show directly underneath the parent, flush to the left like the parent.</p>
  
  <p>So in this case You'd have:</p>
  
  <pre><code>Market
  SubMarket
  </code></pre>
  
  <p>so results for example would be:</p>
  
  <pre><code>California &lt;&lt;&lt; market
  SanJose
  Pleasanton
  Walnut Creek
  
  Illinois &lt;&lt;&lt; market
  Chicago Suburbs
  Chicago
  </code></pre>
  
  <p>... and so on</p>
  
  <p>I cannot figure out why the heck I can't get a child row group to show directly under a </p>
  
  <p>Can anyone help me on this?  I'm truly frustrated with SSRS.  No idea why it doesn't just add the grouping right on the cell I had clicked.  Instead it creates new columns!  Yea by design but why?  and how to get around this.  What I am trying to do seems so simple...yet so hard in SSRS.</p>
  
  <p><strong>Here's an example of what I tried to do:</strong></p>
  
  <ul>
  <li><strong>Creating a Parent Row Group Within a Parent</strong>: If you click a cell within a parent group (in this case Market) and then add another parent group on that cell it'll add a new column in your SSRS report to the RIGHT of the parent that you are in:</li>
  </ul>
  
  <p><img src="https://i.stack.imgur.com/bLB7Z.jpg" alt="enter image description here"></p>
  
  <ul>
  <li><strong>Creating a Child Row Group Within a Parent</strong>: If you are in a Parent Group and click on a cell and add a child row group, it'll add the row to the right of the parent</li>
  </ul>
  
  <p><img src="https://i.stack.imgur.com/bLB7Z.jpg" alt="enter image description here"></p>
  
  <p><strong>What I want this to do is this</strong>, and I can't get SSRS to put that submarket here:</p>
  
  <p><img src="https://i.stack.imgur.com/22pqo.jpg" alt="enter image description here"></p>