Table calculation for pivot 'subtotal'

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.