title: Dropping the sum column in pandas pivot table, but keeping the row
body: <p>So I have a pandas pivot table and I want to keep the sum of the columns at the bottom (so the sum row). However, there is also a column that is added when I say margins=True and I don't want that.</p>
  
  <p>I have tried dropping the column, but dropping a column from a multiindex table just resulted in errors. If I do drop('All', axis=1), it says KeyError: 'All', and if I do axis=0 it gets rid of the total on the bottom (which I want).</p>
  
  <pre><code>artist_table = pd.pivot_table(total_df,
                                values=['Records Created', 
                                        'Tickets Sold'],
                                index=['artist name',
                                       'artist id'],
                                columns=['date'],
                                aggfunc=np.sum,
                                fill_value=0,
                                margins=True)
  </code></pre>
  
  <p>What I want is:</p>
  
  <pre><code>                                 Leads Created       Revenue     
   date                             6/1                 6/2                                        
      artist_id    artist_name      
      XXX           YYY            x                   y            
      AAA           BBB            a                   b            
      All                         (x+a)             (y+b)    
  </code></pre>
  
  <p>What I have now is:</p>
  
  <pre><code>                                Leads Created       Revenue     
  date                              6/1                 6/2           All                                
  artist_id    artist_name      
      XXX           YYY              x                   y          (x+y)
      AAA           BBB              a                   b          (a+b)
      All                           (x+a)             (y+b)                    
  </code></pre>
  
  <p>I would like that All on the right (the sums of the rows) to be gone. Can anyone please help? Thank you in advance!</p>