Forum Discussion
sorting mixed data in pivot table
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
the only data about male female I have, is in the first column, where the letter W or M appear.
there are the next 2 columns that sort the quantity according to gender but the result, as you can see in the screenshot, mixes the 2 while what I need is dividing the two. Meaning, in the column A I would like to have all the items with M first and W after, with the quantities sorted accordingly
alisam1958 , in first column you have values like 102365 W 10 ? How when columns M and W appears in Pivot Table?
