Hello to every one,
I've been trying to group certain columns depending on a value.
I have this table:
I've created a pivot table, all partners/countries are shown, but I want to group certain countries into a "column" inside the pivot table as "others".
This is what I'm trying to get:
The column other should be the sum of the countries which are not shown, those countries will be always the same ones, does not depend on a certain value of qty or value.
Many thanks in advance!
Solved! Go to Solution.
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".
Sure, I've edited the post, I tried the first time to do it, but the second table was not showing properly, cause some fields are combined, I don't know if there is any other option.
Check out new user group experience and if you are a leader please create your group!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Check out how to claim yours today!