Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
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
And if you put an = sign in front of the expression?
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