Dynamic set analysis based on table

[#1]

Hello, I'm currently building a table with set analysis instructions

Group	SetAnalysis_Field
Red group	{$<Color={"Red"}>
Blue Group	{$<Color={"Blue"}>
Green Group	{$<Color={"Green"}>

The idea is to add the group column to a table, so using the  Set Analysis field, set the filter in the operation:

'sum(' & SetAnalysis_Field & ' Volume)'

The concatenation works fine, but i can't make the formula work.

Any ideas of how to do this?

Thank you.

[Anonymous]

Hi, just for a quick response I noticed that you SetAnalysis_Field records are missing the "}" to close off the set analysis.  Also try maybe sum($(SetAnalysis_Field)Volume)

[#3]

thanks for pointing that out but the expression sum($(SetAnalysis_Field)Volume) didn't work

[shanemichelon]

I don't think what you are trying will work.  Set analysis is performed before the table is generated and therefore cannot give different values based on table fields.

[Anonymous]

add that closing brace

and try sum($(=SetAnalysis_Field)Volume)

[Anonymous]

if you want to select multiple groups together you will have to use

concat function

Group	SetAnalysis_Field
Red group	Red
Green Group	Green
Blue Group	Blue

{$<Color={$('"'&=concat(SetAnalysis_Field, ',')&"'")}>Volume)

or you can do the string processing in variable and keep your set analysis expression cleaner