children() function in list header

[rchambers]

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?

[leahmarie]

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.