Multiple Attribute/Cross Tab Analysis

[cdubs34]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Profile[/TD]
[TD]Interested in Sports [/TD]
[TD]Interested in Fashion[/TD]
[TD]Price Conscious[/TD]
[TD]Quality Conscious[/TD]
[TD]Has a dog[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Yes[/TD]
[TD]No [/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]Yes [/TD]
[TD]No[/TD]
[TD]No[/TD]
[/TR]
</tbody>[/TABLE]

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.