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?
unlock cells and place blocks within the cells, and within the blocks place the data items you need
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
Thank you all for the replies. I found unlocking and adding blocks the easiest and quickest one.