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

      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