Forum Discussion
sorting mixed data in pivot table
hello gurus I need some help with a pivot table. I have a column A that has mixed values: meaning, some numbers, a W for women or M for man and additional numbers. Example, 102365 W 10 other colum...
As variant, if you have in your source data the column with male/female you may group PivotTable on this data adding the field on the top of ones which are in Rows.
The columns were there when i created the pivor. I just noticed the screenshot is partial and it looks like it is sorted but below, it is mixed. Columns W and M appear but the result is mixed: first few row show W, then M, then W agai, then Magain. I want them in 2 groups
thank you for your reply.
I am also curious to know how to do it this way but I need it rather like in the attachment
That's slightly depends on your version of Excel. Creating the Pivot Table add data to data model and when in Power Pivot select sorting Item by Gender
If unsorted Pivot Table is like
after applying above Sort By it'll be shown as