Knowledge Drop

Table calculation for pivot 'subtotal'

  • 28 June 2021
  • 0 replies

Userlevel 4

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.                



0 replies

Be the first to reply!