Advanced Excel Formulas
May 14, 2022
May seem like an odd question. I want to show the difference of information over time and use the ability to report connections with a slicer that comes with a PivotTable. My 2 data sets are 2021 and 2022. I want to show the difference in data from 2021 to 2022. When I make a chart of it I only want the chart to show 2022. Not sure if this is possible, if it is great and your advice on how to make it possible is greatly appreciated. The issue that I run into is that since there is a formula connecting 2022 to 2021 if I hide 2021's information the formula stops working and doesn't show the information anymore.