Color Only Subtotal Records in a Crosstab in Tableau Desktop
Published: 20 Dec 2022 Last Modified Date: 20 Dec 2022
How to color only the subtotal records in a Crosstab.
Change the shading setting in the format as described below and demonstrated in the attached packaged workbook.
Create a crosstab. 1. Connect to the Sample Superstore data. 2. Drag Region and Category to Rows. 3. Drag Sales to Text onthe Marks card. 4. Select Toolbar > Analysis >Totals > Add all sub totals. 5. Select Toolbar > Analysis > Totals > Total all using > SUM
Change the format settings as described below. 6. Select Toolbar > Format > Shading. 7. In the Format Shading pane, change the setting as follows:
Thank you for providing your feedback on the effectiveness of the article.