PERCENTOF
Description
Sums the values in the subset and divides it by all the values.
This function is useful for determining ratios and calculating percentage contributions within grouped data.
Syntax
PERCENTOF(
data_subset
,data_all
) - data_subset: The value that is in the data subset.
- data_all: The values that make up the entire set.