I need to achieve the following:
***********************************************************
AA_Item New Retro BB_Item New Retro
mbr 1 50 13
mbr 2 75 80
mbr 3 43 22
***********************************************************
New and Retro aren't fields. They are blank columns on my report that I will export to excel, send to a client and the client will fill in the new $ and then the retro $. There is no set calculation to these numbers that I can derive from a formula. Each mbr could have any dynamic number of item columns whether it be an AA and BB or unlimited. This is why I'm thinking I need a crosstab.
HOWEVER, I do I display 2 fake dummy columns side by side for each item?
ANY direction you can give me would be MOST helpful as this is driving me crazy!
***********************************************************
AA_Item New Retro BB_Item New Retro
mbr 1 50 13
mbr 2 75 80
mbr 3 43 22
***********************************************************
New and Retro aren't fields. They are blank columns on my report that I will export to excel, send to a client and the client will fill in the new $ and then the retro $. There is no set calculation to these numbers that I can derive from a formula. Each mbr could have any dynamic number of item columns whether it be an AA and BB or unlimited. This is why I'm thinking I need a crosstab.
HOWEVER, I do I display 2 fake dummy columns side by side for each item?
ANY direction you can give me would be MOST helpful as this is driving me crazy!