Forum Discussion
Column into single row
Hi All, I have a single table called RDSS(voting) which has a column for each state(state_ab), division(div_nm) & candidate 1 & 2(cand_num) and there is a row for each candiates voting results & ...
To do this you have to:
1) Either find a custom visual that will let you do that (but I doubt you'll find something like this).
2) Create a measure that will return the party of the candidate.
You can easily see that it's not possible to do what you want using the columns from your table and the table/matrix visual because when you drop a column onto the visual this column slices the data in your table. Hence the output you get. If you create a measure that will return this piece of data, then you'll be able to show the different party for each candidate on the same row just the way you want it.