BLACK FRIDAY SALE 20% OFF ALL COURSES

Matt Flynn
Member
Members
Dashboards
Advanced Excel Formulas
Dashboards
Advanced Excel Formulas

Forum Posts: 10
Member Since:
May 14, 2022
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.
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Steven Alker, Sherry Fox, Jill Niemeier, Pam Baillie, Stacey Wells, Sheryl Gill, Ben Penney, Phil Collins, Todd Heckman
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1864
SunnyKow: 1432
Anders Sehlstedt: 886
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 241
Hans Hallebeek: 227
Jessica Stewart: 219
A.Maurizio: 213
Newest Members:
Anya Ledwith
Mark Melvin
Stuart McInnes
Naji Moukhachen
Robert Mason
Debora Cohen
Kris Whitaker
Rajesh Jawajala
Todd Heckman
Sarah Dennis
Forum Stats:
Groups: 3
Forums: 24
Topics: 6641
Posts: 29138
Member Stats:
Guest Posters: 49
Members: 33095
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —
