Forum Discussion
Group columns on pivot table
Hi ciervax
I tried JW_van_Holst 's solution and create a pivot table like below. The output is the same as your expected result. Is this what you want?
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
In power query add an column:
In your pivot table select _Partner in stead of Partner and it should do the job.
Good luck,
//JW
Thank you for your help.
The problem I see, is the new column _Partner is marking all fields as others, even if the country in partner is not listed as "Australia", "etc"
Then if I select _Partner as a column instead of Partner, is showing only the column Others cause the column is containing all countries.
I don't know why it is not reading the list properly, and all rows are "Others".
Hi ciervax
I tried JW_van_Holst 's solution and create a pivot table like below. The output is the same as your expected result. Is this what you want?
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.