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 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?