If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Crosstab Intersection Calculation

Started by bfmooz, 11 Apr 2011 09:43:56 AM

Previous topic - Next topic

bfmooz

I'm hoping someone has come across this issue and knows a way to address it.

I have a crosstab report.  Across the columns, I have dropped in Months.  Down the rows, I have static members of an Accounts hierarchy.  I have a measure intersecting them for Period Amount.

For the Accounts, there are certain one where a sign reversal needs to be done, e.g. Total Sales.  So for example, the measure intersecting Month 1 and Total Sales needs to equal Period Amount X (-1), but the measure intersecting Month 1 and Total Cost of Sales needs to equal Period Amount.

Any suggestions on how this could be done given that I am using static members down the rows?