4 Replies Latest reply: Jun 8, 2012 9:39 AM by Nicole Smith RSS

    Include calculated dimension in expression

    brandon breitling

      Hi Community,

       

      I have a calcuated dimension I would like to have in the expression of a pivot table(for user functionality reasons.)

       

      the calcluated dimension is if(leafhdrtxt=[Division Abbreviation],[Division Abbreviation])

       

      The expression to tie it into is:

      -1*sum({ $<  balcode={'ACTUAL'},

      LinkYear= {$(=$(vCurrentFiscalYear))},

      LinkMonth=CurrentDocumentMonth3,

      [code]={'DPCOMP'}

                   >}PeriodTotal/1000)

       

       

      Any ideas?