This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit FeedbackA solution to last week’s challenge can be found here.
When working with a traditional spreadsheet, it's relatively straightforward to summarize over rows and columns. But we often would like to do something similar in Designer! We also have the added feature to be able to create reports in a variety of formats.
For this challenge, find the total cost for all food items for each country as well as the total cost for each food item. Then create a report of your choice to show your findings.
Hint:
How to Generate and Format Totals and Subtotals
Transpose > Cross Tab wombo combo!