4 Replies Latest reply: Oct 11, 2012 5:17 AM by Bruno Santos

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

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.

Bruno

• ###### Re: Use an expression in pivot table which was previously loaded in a table

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))

• ###### Re: Use an expression in pivot table which was previously loaded in a table

Sorry,

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

How can I run an expression stored in a table.

Thanks

Bruno

• ###### Re: Use an expression in pivot table which was previously loaded in a table

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

• ###### Re: Use an expression in pivot table which was previously loaded in a table

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