Knowledge Drop

Table calculation for pivot 'subtotal'

  • 28 June 2021
  • 0 replies
  • 178 views

Userlevel 3

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!

Reply