I'm not sure if I understood what you need, but try this:
=GetFieldSelections($(=pick(match(GetCurrentField([New Group]), 'Dim1', 'Dim2', 'Dim3'), '', 'Dim1', 'Dim2')))
In the Match() content, replace the Dim1, Dim2, Dim3 with your Dimensions in the correct order.
In the Pick() content, do the same, but consider that it must pair the Upper Dimension so the Lower dimension will not appear here.
Attached a sample.
Hope this helps you
Sample.qvw 186.0 K
yes, that example looks exactly like what I want. The textbox only displays the next-upper value from out of the drilldown group. I don't quite understand the syntax of your expression yet, but I'll try to redo it that way in my document.
Thanks a lot!
P.S.: One more question rgd. this and a problem:
- Problems first: I get an error in the expression when I enter the name of my group: The name is >Packbereich< - in the label_field in the >edit group< dialog, there is exactly that name, too.
- A question: Once I have this working so far, can I expand it - and how - to encompass more levels (I will have five or six in the end, the very first (actually not part of the drilldown group) will be a date selection and then there will be four or five drilldown levels.
Thanks a lot!
P.P.S.: Ok, the problem is solved - don't ask me how, I changed it and changed it back and now it's seemingly the very same as before, but it works ;-)
So only the question of expanding that syntax remains.
To encompass more levels and consider the Date selection as the first, you just have to add them as following:
=GetFieldSelections($(=pick(match(GetCurrentField([New Group]), 'Dim1', 'Dim2', 'Dim3', 'Dim4', 'Dim5', 'Dim6'), 'DateField', 'Dim1', 'Dim2', 'Dim3', 'Dim4', 'Dim5')))
Hope this works.