1 Reply Latest reply on Oct 8, 2012 8:47 AM by Jonathan Drummey

    Different Shading multiple subtotals

    William Ohara

      I spent a couple hours playing and researching online but to no avail.  I have a crosstabe sheet that I want the different subtotals to have a different shading plus I want the subtotal line to read the field name + total.  Currently each subtotal line just says total and the same shading so it is confusing to what is actually being subtotaled.  I want the subtotal to say Program Totals or Plan Totals..whatever the field that is subtotaling on plus then set the shading or fonts to change...I see where I can change grand totals to a different shade but how does one change the different subtotals?

       

      Thanks

       

      Bill

        • 1. Re: Different Shading multiple subtotals
          Jonathan Drummey

          Hi Bill,

           

          You can format the shading for subtotals separately from grand totals using the Format->Shading->Total section, but this will only give you one color per subtotal, and doesn't let you customize the text. You can change the text from "Total" to something else in the Format window->click on the Fields drop-down->choose the field->Header tab->totals section, but this only gives on value per total. The Basic Shading worksheet in the attached has that set up.

           

          See the attached for a solution that at least gets you custom Total headers. I used duplicated data via custom SQL as well as custom fields to create the format. the methods are outlined in http://drawingwithnumbers.artisart.org/customizing-grand-totals-part-3/ and http://drawingwithnumbers.artisart.org/customizing-grand-totals-part-2/. You weren't clear about how much formatting you wanted to do on the headers vs. the data. Header formatting is pretty limited, for example you can't arbitrarily set some members of a dimension to be in bold and some normal weight, and you've already run into limitations of banding. In terms of columns, you can do stuff with size and color, but not font weight, I played with both in the attached. If you want to get really custom for that, you can use a multiple axis crosstab with dual axes for a column, the technique is outlined in http://public.tableausoftware.com/views/conditionalformattingv4/Introduction. If you were willing to limit yourself to having a fixed column size for both the header and the values, you could create an additional axis that would have the totals and then you could individually color the subtotals and totals.

           

          Cheers,

           

          Jonathan

          1 of 1 people found this helpful