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

    Include calculated dimension in expression

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






      Any ideas?