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

The expression to tie it into is:

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

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

LinkMonth=CurrentDocumentMonth3,

={'DPCOMP'}

             >}PeriodTotal/1000)

Any ideas?

[Oleg_Troyansky]

Not sure what are you trying to achieve with the calculated dimension, and what do you mean by "tying the expression" to it? Please clarify the desired goal and the question.

[#3]

I have a pivot table with the inner most dimension as the calculated one above.  I would like to have the dimension as just division abbreviation and include the calculated part in the expression for the chart(same as one above.)

[#4]

I had to use the calculated dimension to get the chart to give the right value

[Nicole-Smith]

Try this:

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

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

LinkMonth=CurrentDocumentMonth3,

[code]={'DPCOMP'},

leafhdrtxt=[Division Abbreviation]

             >}PeriodTotal/1000)