Hello,
I need to create a column that combines a year column and a period column. Currently, I have year and all 12 periods in a list report displaying account totals. Then I render a period based on a value prompt and filter year based on a prompt. I then need to perform a difference calculation for current period and previous year based on the period selection.
This is what I have currently:
Acct |Year | Oct
0002 |07 | 200
0003 |08 | 200
Goal:
Acct |07/OCT | 08/Oct | Difference
0002 |200 | 200 | 0
0003 |200 | 200 | 0
This is like a cross tab but I have experienced that I could not set the render variable for cross tab members.
Any help and suggestions welcome
Hi
First question are you using a relational source or DMR? If you're using DMR I think you can do this in a xtab using the tuple function (check out help to see how to use a tuple).
If you're using a relational source try using a couple of sub queries; one for each year, join them together in a 3rd query then you can choose which columns to display in the report and do the calculation.
Good luck