Coming Soon! We’re launching a new sub-community within the Google Cloud Community dedicated to cloud security: The Google Cloud Security Community. In preparation for the launch, this site will be in read only mode from 22 September 12am PST - 23 September 7pm PST

Table calculation for pivot 'subtotal'

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.

This content is subject to limited support.                

Version history
Last update:
‎06-28-2021 11:51 AM
Updated by: