i have a list the has headers for "Last Quarter" and "Current Quarter." i am working against a transformer cube, and i want the list headers to use "children(Last Quarter)" to show the actual value of the "Last Quarter"; e.g., "2011 Q2"
is this possible?
Did you try creating a data item and using it in the report? I have never used transformer cubes, but when I use dimensional reports I use that function all the time in data items and it works great. Be sure to use a data item though and not a calculated member.