Only function aggr inside set analysis

[jsobrinho]

HI guys,

Why the expression doesn't show the values for this filter by Only function and aggr function?

[rubenmarin · Accepted solution]

Hi, when a function retuirns more than one value you need a n aggregation funcion to return only one value.

Aggr() will return one value for each P, when there is a dimension with limits by one P value only one value of Co is shown, thats why is shown on rows, on totals rows aggr will return diffrent values, in example you can do a Concat():

Concat(Aggr(...), '","')

It will return one single value, a string that separates values using double quotes and a comma, wich inside the set analysis will use the starting and finishing double quotes to make a valid syntax.