A list within a drill down group

[helen_pip]

Hello

Is it possible to have a drill down list in a table, and as soon as you go past a certain level a list of details appear

I.e.

In Group is;

Type

Diagnostic

Then when you click on a Diagnostic you will have a list of people and their demographic information and no ability to drill down any further

Name, Address,  DOB, Post Code,

Can this be achieved?

Thanks

Helen

[#2]

try to add expression for each information (Name, Address,  DOB, Post Code,) and set conditional show (chart properties -> presentation -> columns -> conditional show) using getcurrentfield() function

[#3]

i mean :

=if(getcurrentfield(GroupName)='Diagnostic',1,0)

[helen_pip]

Hello,

Thank you for your reply

I ahve tried your technique, but cannot get it to work accurately. Could you kidnly take a look at the attached QVW on the original post to see where I may be going wrong 

Kind Regards

Helen

[#5]

Where is Your file?:)

[helen_pip]

Hello

The file is there now.....Thanks for any help

Helen

[#7 · Accepted solution]

check this..

[helen_pip]

Hello

Thank you very much

Much appreciated

Thanks

Helen