reportingcognoscognos-10cognos-bi

COGNOS: Calculation in a cross table based on condition from other dimension


. Hello all,

does anyone now if there is a function to calculate a measure based on 'Assets' with the condition of "Profit Center Contribution" or "Funding Center Contribution". (see image below)

enter image description here

Thanks in advance


Solution

  • If you are using a DMR model you could use the tuple function. Assets -FCC= tuple(Profit Center Contribution, assets, currentmeasure)