Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
only({<leafhdrtxt=[Division Abbreviation]>} [Division Abbreviation])
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)
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?
use in express same code
if(leafhdrtxt=[Division Abbreviation],[Division Abbreviation])
hope this help