Pivot Table - Total doesn't work with condicional formatting (gradient)


I’ve found that the row total in a pivot table doesn’t work if adding condicional formatting.

I using a calculated field with a very simple metric of share in percentage, being the sum of a field divided by the sum of another field like below:
Example calculated field: Conversion = sum({column1}) / sum({column2})

In row, I created a column with just a string “Total” to able to bring a row:
Example calculated field: total = “Total”

Without condicional formatting, we can see that the row total appears.
Now, including condicional formatting with fill type like gradient, it doesn’t bring the total:

I appreciate any help, thank you!

Hi @dsaraiva

Yes this isn’t a feature currently. I can mark it as a feature request.

1 Like