Section a List/Crosstab

Question

I need to section a list based on values of a column, example want the list to be split up based on values of School. Currently, it all appears as a long list.Current Output using List / Crosstab:School&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Candidate&nbsp; &nbsp; &nbsp; Marks&nbsp; &nbsp;Grade-----------------------------------------School A&nbsp; &nbsp; &nbsp; Candidate 1&nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ASchool A&nbsp; &nbsp; &nbsp; Candidate 2&nbsp; &nbsp; 14&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BSchool A&nbsp; &nbsp; &nbsp; Candidate 3&nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BSchool B&nbsp; &nbsp; &nbsp;&nbsp;Candidate 4&nbsp; &nbsp; 22&nbsp; &nbsp; &nbsp; &nbsp; ASchool B&nbsp; &nbsp; &nbsp;&nbsp;Candidate 5&nbsp; &nbsp; 15&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BSchool B&nbsp; &nbsp; &nbsp;&nbsp;Candidate 6&nbsp; &nbsp; 12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B&nbsp;Desired Output:School ACandidate&nbsp; &nbsp; &nbsp; Marks&nbsp; &nbsp;Grade-----------------------------Candidate 1&nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ACandidate 2&nbsp; &nbsp; 14&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BCandidate 3&nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B&nbsp;School BCandidate&nbsp; &nbsp; &nbsp; Marks&nbsp; &nbsp;Grade-----------------------------Candidate 4&nbsp; &nbsp; 22&nbsp; &nbsp; &nbsp; &nbsp; ACandidate 5&nbsp; &nbsp; 15&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BCandidate 6&nbsp; &nbsp; 12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B

amitchandak · Answer

vini_udenia ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format?
Appreciate your Kudos.

vini_udenia · Answer

Hi Amit, I've updated the description

v-xuding-msft · Answer

Hello @vini_udenia ,
 
What do you mean, the section of a list? Do you want to create two new tables? If so, you can try this:
School A =
SELECTCOLUMNS (
    FILTER ( 'Table', 'Table'[School] = "School A" ),
    "Candidate", 'Table'[Candidate],
    "Marks", 'Table'[Marks],
    "Grade", 'Table'[Grade]
)

If you don't want to create new tables, you can use a slicer to filter them or use an array visual to display them.

Forum Discussion

Section a List/Crosstab

3 Replies