Hi all
I've created a pivot table, summarizing each markets value.
I want to show the Top10 markets (Thats easy: Filter -> Top10)
But how can I add an other category. I want to see the rest of the markets in it
One way I used to do this:
Create a 2nd pivot table: filter the top10 countrys and Group - Rename to other
But I dont like it that way. I want it all in one pivot table. I guess I have to change the original data?
Thanks for the help
I've created a pivot table, summarizing each markets value.
I want to show the Top10 markets (Thats easy: Filter -> Top10)
But how can I add an other category. I want to see the rest of the markets in it
One way I used to do this:
Create a 2nd pivot table: filter the top10 countrys and Group - Rename to other
But I dont like it that way. I want it all in one pivot table. I guess I have to change the original data?
Thanks for the help