Pivotstyle modify – totals

We use modified pivot tabel syles – does the grand total format always override the row subtotal formats or can I change where they overlap?  Youc an see my problem quite clearly below: The subtotal headings disappear intot he column totals.  It is not going to change the world but if there is a way I can make subtotal 1 foramt at tleast override the column grand total format the tables would read much easier.

 

page (All)              
                 
      Values head        
      Sum of first Sum of second Total Sum of first Total Sum of second
title subtile type a b a b    
title1 subtitle1 type1 100 200 200 200 300 400
  subtitle1 Total   100 200 200 200 300 400
title1 Total     100 200 200 200 300 400
title3 subtitle1 type2 300   200   300 200
  subtitle1 Total   300   200   300 200
  subtitle4 type1   400   200 400 200
    type2 500   200   500 200
  subtitle4 Total   500 400 200 200 900 400
title3 Total     800 400 400 200 1200 600
Grand Total     900 600 600 400 1500 1000

By: ruth ballinger

Leave a Reply

Your email address will not be published. Required fields are marked *