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

merge rows in crosstab report

Started by cham, 22 Jan 2012 10:15:51 PM

Previous topic - Next topic

cham

Hello Gurus,

I have a dashboard report which has YTD and monthly values. Now I got a new requirement of a metric which has different calculation for monthly and YTD. If I get the values of monthly (metric a_monthly) and YTD (metric a_YTD) from the database itself, can I show the values in a row in the crosstab? The metrics are as rows in the crosstab. But the requirement is to show YTD and monthly values of the metric in a row. If I pull from database, it actually creates to metrics. If I pull these two metrics(a_monthly and a_YTD) in crosstab, it will show 2 rows. Instead, I want to show them in a row. my model is DMR. Not sure how to perform this. I know how to hide columns, but here I have to take the monthly values of a_monthly metric and YTD value of a_YTD metric and merge these two and show it in a row in a crosstab.

Please help me in this regard. I need it urgently.

thanks you in advance!