Knowledge Drop
Last tested: Apr 9, 2020
sum(pivot_row(if(${view_name.pivot_field} = 'condition', ${view_name.measure}, 0)))
This table calculation adds up all the measures where a certain condition is met by the pivoted field. You will need to create a table calculation for each pivot value.