How to add a "street" field for each constituent in Analytics?

Hi , I am also interested in this. Analytics provided me with a much faster way to pull all the info I need for our weekly donation letter mail merge, but I also need the street address field. 

Look up how to add a Custom Category in Analytics. You only get 10 of them.

You will have to figure out the SQL query that gets you the data you seek. You should generally use secured Views instead of tables. And finally, you have to use an aggregation, e.g. MAX, so that the result set only has one row (per constituent in your case).

After you attempt to add a Custom Category, If Analytics fails to refresh the next time it should, that means you didn’t write the query correctly to only get one row.

Look up how to add a Custom Category in Analytics. You only get 10 of them.

You will have to figure out the SQL query that gets you the data you seek. You should generally use secured Views instead of tables. And finally, you have to use an aggregation, e.g. MAX, so that the result set only has one row (per constituent in your case).

After you attempt to add a Custom Category, If Analytics fails to refresh the next time it should, that means you didn’t write the query correctly to only get one row.

If you use where primary_ind = 'Y' address you should get one per constituent (?)
Actually bi.VT_CUSTOMER has primary street address built in

I'm still quite unfamilar with SQL, but I've figured out a work around. Hoping to dive into SQL some day!