WITHOUT A PIVOT TABLE. ONLY USING FORMULAS Create a new worksheet called R01_DASHBOARD and create a dashboard based on the SALES table that resembles the template shown in Appendix A, with each city in the dataset represented.

The table continues from years 2018 until 2022 showing each cities total sales during what month. How can I include a drop down menu that dynamically updates the data for each year in an appendix a format.

\begin{tabular}{|l|r|} \hline Year & 2020 \\ \hline \end{tabular}