Hi All,
I'm currently writing a cross-tab report in Cognos report studio and I'm stumped on how I would achieve this:
I have a sales by product group by month, Year. I need to add a summary to the right of the cross tab that looks at comparing LY to This year sales figures. The cross tab will only ever have current year, and previous year sales data.
I've attached an excel output of what I'm trying to achieve. The fields I've highlighted in yellow are what is currently missing from the report. All my other fields are working as expected.
I could create another list in this report below the cross tab, but I really would like to show it in the cross tab if possible.
If anyone has any suggestions I would greatly appreciate your help.
Hi - can you give us a bit more information about your structure? Are you writing your cross tab report over relational or dimensional data? If it's dimensional do you have a date dimension that you can use?
Hi BigChris,
Thank you for your response. I ended up figuring out a way to achieve this by creating two new fields in my query and summing the data based on the current/LY date using IF statements. I then used these fields by creating another column calling it Totals Current and Totals LY and it seems to be working.