Style Pivot table Subtotal header and cell differently

I have a pivot table and it lists the counts by quarter. I added a subtotal column to sum the number by year.
Table is shown below:

Is there any way to style the header and cell differently for the subtotal column (currently, background is all in grey). I wanted to have the subtotal background in blue (like other headers) and the cell background stays grey. If I click apply style to cells under Subtotal, they all have the same background color. If I unselect this option, then I can’t distinguish subtotal column with other cells (background in white).

Hi @kiko,
Unfortunately the styling options on tables/pivot tables in QS still have some limitations; cell coloring seems to be one of those features.

While the current styling options don’t allow this, a work around you could explore would be to create a separate visual for your subtotal section and place it on top of your other visual. (you hide the background, border and selection so that it lines up more accurately).

As this is not an ideal workaround though, I’ll mark this as a feature request to promote visibility to the support team.

Thank you

1 Like