Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI guys,
Why the expression doesn't show the values for this filter by Only function and aggr function?
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.
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.