Countifs

Count of values based on inputs and group. It will return a new table.

Function:

CountIfs(table = string, cols = list, count_col = string, new_table_name = string)

Parameters:

Table: Table name on which to perform function

Columns: Columns that you wish to group

Count Column: Value column you wish to return counts

New Table Name: Name for new table

Examples:

CountIfs(table = Budget, cols = [Business_Unit, Geo], count_col = Amount, new_table_name = CountbyBU&Geo)