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

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

    Bruno 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 (#)] = ,



      Month = >}Amount),Line))



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

      Thanks in advance.