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

Hi Thanh, Michelle, Brian,

Andy covered it below, but I'm curious, given the available Output Elements for address information, what brings you to Analytics to pull these outputs rather than using List Outputs? 

Thanks,
Chris

Hi Chris, I am pulling the total amount contributed by constituent for 4 specific funds from the past week. A pivot table in analytics makes this very easy. I alsp need their contact info for our mail merge (name, address, email) to send our donation letters. I figured out a work-around for the Street field. I saved a list from the pivot table and then used an output set to pull Street. If the widget and output set are both sorted the same (i.e. Id ascending), I can easily copy and paste the street columns from one excel sheet to the other. This might sound like a lot of leg work, but it's actually MUCH easier then what I was doing before. 

Hi Chris, I am pulling the total amount contributed by constituent for 4 specific funds from the past week. A pivot table in analytics makes this very easy. I alsp need their contact info for our mail merge (name, address, email) to send our donation letters. I figured out a work-around for the Street field. I saved a list from the pivot table and then used an output set to pull Street. If the widget and output set are both sorted the same (i.e. Id ascending), I can easily copy and paste the street columns from one excel sheet to the other. This might sound like a lot of leg work, but it's actually MUCH easier then what I was doing before.