Mapping work arounds?

[james]

All, I have an interesting scenario where I have a field that has 7 possible values and 7 corresponding text values that are linked, i.e.

Value, text

0, This number is zero

1, This number is one

2, This number is two

My dilemma Is that I need to have the comparable "text" field as the title for 7 different Pivot Tables, without having to select anything. I know you can use set analysis to do this in instances where you are using aggregations, but my scenario does not have that. All I need for it to do is basically return the text

I have tried MAPPUING and I always receive NULL

Any ideas? Thoughts examples?

[#2]

Still you can use set anlysis, right?

=only({1<Value={'0'}>} text)

[#3]

Have you looked at DUAL ? It can be used in the loadscript to associate a number and a text value - it may give you a field name to use in your titles.