We are trying to produce an excel file which includes Family Info displaying:

• Last Name
• First Names of Head of House and Spouse
• address information.

I was able to extract the population correctly using "Family Analytics Dim" but not sure how I can display the above information.   The Family Title seems to include the Nicknames and Last name in one field.   We also do not want the word "Family" in the content like the Family Name.

I am guessing this would be a Lava Field.   I know I can do this using Pivot Tables but want to set it up for our users with one-step process.

Does anyone know how to do this?

Thank you.   Vicky