Combining Columns

[N013]

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

[wyconian]

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