Right click the Tableau subtotal in the Product Category column. Now, the only row banding will be on the Tableau subtotal’s lines.ġ9. This option removes any color banding to make the table more readable from the rows. In this case, set the Pane and Header drop downs for row banding to None. Level enables you to control where you want the banding to occur.ġ8. Band Size almost always leave to the default of 1. There are also 2 sliders: Band Size and Level. You can use these to add shading to the rows of your table to make them more readable. Under the Row Banding section, there are two drop downs, Pane and Header. In this case, we only want the Tableau subtotals formatted.ġ7. Often when you change the Totals section above, Tableau defaults to formatting that as well. Under the Grand Total section, ensure that those are both set to none. First, go to the Totals section, and under the Pane drop down, set the color to a light blue. You’ll see several sections that we’ll utilize. Click the paint can icon at the top of the format window.ġ5. Be careful to format only the totals (seen in the middle of the formatting pane under the header Totals).ġ4. The formatting menu will again pop up.ġ2.
Right click the Tableau subtotal that is in the same column as Marketing Channel field. Right click where those are still black and follow the same procedure as before.ġ1.You have to specify you want those to look the same. However, it leaves the headers for the measures off. Note that it formats the headers along the dimensions in blue as desired.A box will appear prompting you to change different formatting elements. Format the headers of the table by right clicking on them at the top and choosing Format.ġ0. Go to the drop-down box on the top toolbar that says “Standard.” Change that to “Fit Width.” This will provide more space for our columns, making them more readable.ĩ. Now let’s add some formatting to the table to make it more readable.Ĩ.
How to Format Tableau Subtotals and Grand Totals Instead, Tableau will create a subtotal for each Customer Segment and Marketing Channel. That data is already shown and subtotaling it in Tableau would be redundant it would show the same thing. In this case, Product Category is the lowest level of granularity, so you won’t add a Tableau subtotal to each procedure (each row of the table).