Hello,
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!