Include calculated dimension in expression

[#1]

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])

Any ideas?

[Nicole-Smith]

only({<leafhdrtxt=[Division Abbreviation]>} [Division Abbreviation])

[#3]

Let me rephrase that.  How would I tie that in with the current expression of:

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

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

LinkMonth=CurrentDocumentMonth3,

={'DPCOMP'}

             >}PeriodTotal/1000)

[Nicole-Smith]

I'm not sure what you're trying to accomplish.  How are you trying to tie it in?  What is the calculation that you're trying to do?

[SunilChauhan]

use in express same code

if(leafhdrtxt=[Division Abbreviation],[Division Abbreviation])

hope this help