Let's assume that you are tracking the financial records of your company and your boss wants you to deliver two reports every week, containing the total amount of sales that you made for a particular week and the total amount of purchases you made toward the company's stores. How would you go about it?
You can always select all of the instances of sales and then calculate the sum of them. Once that is done, you have to again select all instances of purchases made and find the sum of purchases too. Having to do so frequently would be really time-consuming and boring. Here's where the CHOOSE function comes into play! We can implement a simple model that does everything for you in one click, using the following ...
