Multiple Attribute/Cross Tab Analysis

[cdubs34]

Profile	Interested in Sports	Interested in Fashion	Price Conscious	Quality Conscious	Has a dog
1	Yes	Yes	No	Yes	No
2	Yes	No	No	Yes	No
3	No	Yes	Yes	No	Yes
4	Yes	Yes	Yes	No	No

<tbody>
</tbody>

Hi All,

I am working with a data table set up like above, but much larger with more profiles and rows (attributes). I was wondering if there is a way to easily set up the data in a different way or some other solutions to quickly get at insights like x% of profiles are Interested in Sports and Fashion, and are Quality Conscious and have a dog. Let me know if you have any questions or if this is unclear. Thank you!

 

[James006]

Hi,

Just insert a Pivot Table ... :wink:

Hope this will help

 

[cdubs34]

Hi James,

Thanks for the quick response. I am familiar with pivot tables, but in this case, with the data set up the way it is, it doesn't (unless I am doing something wrong with pivot table set up) get to what I am looking for. Any ideas on changing the data layout or anything like that? Thanks.