SCENARIO
A marketing director at a mobile business startup has a user data spreadsheet. There are a total of 10,000+ records in it, and one column of it holds the users’ country information. She wants to know what countries these users represent, what the top 5 countries are among them, the percentages of each of the top 5, and the percentage of the top 5 together among all represented countries.
SOLUTION
Use a WorkWaltz custom automation tool to process the spreadsheet and generate a pivot table in less than a minute. The pivot table will list all represented countries and the user count, percentage, and rank for each country. The table will be sorted by rank and will also provide the combined percentage of the top 5 countries.
Way cool! Some very valid points! I appreciate you penning this article and the rest of the site is
also really good.
Make more new posts please 🙂
___
Sanny
I admire your piece of work, regards for all the good content.