The owner of a new wine store has an Excel spreadsheet that lists the wine origin, varietal, and sales volume of each transaction of the store in its first month in business. There are total of 9 origins, 9 varietals, and 200+ transactions. He wants to know the sales volume of each of the 81 combinations of the origins and the varietals, as well as the total volumes for each origin and each varietal. He figures that it’s too complicated for him or any of his employees to do the job manually using the available Excel features.
Use a WorkWaltz custom automation tool to generate the pivot table for the exact data summaries he wants, in 50 seconds.