Help transforming a table? Or pivoting?

[thmonte]

How can I pivot a table that is in this structure:

Home	Away	Boy	Girl
Yes	No	Yes	No
No	Yes	No	Yes
Yes	No	Yes	No
Yes	Yes	No	Yes

Into something like this to report on

	Yes	No
Home	3	1
Away	2	2
Boy	1	3
Girl	2	2

I thought this is called pivoting but apparently not?

I also want to keep this relational in a sense that if i interact with any of the Yes/No count I can see the corresponding records from the first table that has it.

[nirvana_moksh]

@thmontePivot the first table that you gave will return this:

Pivot 

Which you want to do first, and then drop in a matrix and have the attribute in Rows, in Columns have the Values and in Values have count of Values like this:

Final Result

[thmonte]

Is there anyway to create a relationship to drill back inott he original record?

[nirvana_moksh]

@thmonte- if you set up multiple hierachies you can drill up and down