Help transforming a table? Or pivoting?

Question

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 · Answer

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 · Answer

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

nirvana_moksh · Answer

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

Forum Discussion

Help transforming a table? Or pivoting?

3 Replies

Related content

Table Transformation

Table Transformation

Table Transformation

Transform pivot table with two coluns

Table Pivot, result explanation