In this blog post I walk you through a number of different ways to tackle a question. I had a user who had to identify the correct rate for something based on country of origin and product type. You can download the completed file here. Watch the video here to see how it is done.
- Meet Aggregate – the function that helps you wrangle hidden rows and subtotals in your formulas..
- How to identify total of top three scores
- Creating a KPI Dashboard – Part Five – Putting it all together in our dashboard
- Creating a KPI Dashboard – Part Four – Putting together our annual stats
- Creating a KPI Dashboard – Part Three – Preparing our monthly stats