MULTISELECTCHANGEAGGREGATION

Creates a multiselect xml by referencing an existing multiselect xml and changing the aggregation function.

Syntax

=MULTISELECTCHANGEAGGREGATION("multiselect xml","new aggregation function")

Example

Cell C4 contains this multiselect xml:

<?xml version="1.0" encoding="utf-16"?>
<MultiSelect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Hierarchy>[product]</Hierarchy>
  <AggregationFunction>Sum</AggregationFunction>
</MultiSelect>

This function creates the same xml but with "Any" as the aggregation function:

=MULTISELECTCHANGEAGGREGATION(C4,"Any")

Valid aggregation functions are: Sum, Avg, Aggregate, Min, Max, and Any.