Stay organized with collections
Save and categorize content based on your preferences.
The pivot_where function can be used in a table calculation to select a pivot column by a condition.
Syntax
pivot_where(select_expression, expression)
The pivot_where function returns the value of expression for the pivot column which uniquely
satisfies select_expression or null if such a column does not exist or is not unique.
Examples
In the following example we look for the pivot column that is based on "Order Status", and has a value of "pending". If we find it, return the "Order Count" in that cell: