Forum Discussion
thmonte
Helper IV
Helper IVHelp transforming a table? Or pivoting?
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 ...
nirvana_moksh
Impactful Individual
Impactful IndividualthmontePivot 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
thmonteIs 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