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

showing a row of data in two rows

Started by kiran.timsina, 26 Feb 2013 01:48:42 PM

Previous topic - Next topic

kiran.timsina

I have a row of data as:
Item/Location/YTD TY Rtl/YTD TY Cost/YTD LY Rtl/YTD LY Cost
I need to develop a report in the format as:
Item1/Location1/YTD TY Rtl    / YTD LY Rtl
                         /YTD TY Cost / YTD LY Cost
Item2/Location2/YTD TY Rtl    / YTD LY Rtl
                         /YTD TY Cost / YTD LY Cost

I tried this using crosstab space (with fact cells) in a crosstab report. I get nothing, just blank, when I place two metrics on the same column and I get two rows of same metric if I place only one metric in a column. How can I solve this?

adik

unlock cells and place blocks within the cells, and within the blocks place the data items you need

blom0344

Use a union with a dataitem 'type' that has the values  'cost' and 'rtl' for the respective queries. Use the 'type' item in the crosstab row. You can suppress the 'Cost'  line values of Item / Location by checking the 'type' value 

kiran.timsina

Thank you all for the replies. I found unlocking and adding blocks the easiest and quickest one.