Use an expression in pivot table which was previously loaded in a table

[bruno_m_santos]

Is it possible to use an expression in a pivot table, which was previously loaded in a table?

My pivot table is linked to formulas table, by Schema and line fields.

Sample formula to Line L005:

sum ( aggr( sum(TOTAL{$<MonthID = {$(=Max(MonthID))},

Date = {"<=$(=Max(Date))"},

Year = ,

Quarter = ,

Period = ,

[Period (#)] = ,

Schema={TEST},

Line={L005},

Month = >}Amount),Line))

So in my pivot for a specific Schema and Line, I want to run the corresponding expression.

Thanks in advance.

Bruno

[Gysbert_Wassenaar]

The values for schema and line should be in quotes:

sum ( aggr( sum(TOTAL{$<MonthID = {$(=Max(MonthID))},

Date = {"<=$(=Max(Date))"},

Year = ,

Quarter = ,

Period = ,

[Period (#)] = ,

Schema={'TEST'},

Line={'L005'},

Month = >}Amount),Line))

[bruno_m_santos]

Sorry,

but my problem is that the expression, in my pivot is treated like a text not an expression.

See the image please.

How can I run an expression stored in a table.

Thanks

Bruno

[Gysbert_Wassenaar]

And if you put an = sign in front of the expression?

[bruno_m_santos]

Same result

My expression in Pivot is "=Expression"

Returns the expression text (now with "="), but doesn't execute the expression. If I copy cell text, and create another column with the copied expression returns values.

Any idea

Bruno