
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: Kim Knox, Tiffany Kang
Guest(s) 11
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 871
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
Jessica Stewart: 204
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Maria Conatser
Jefferson Granemann
Glen Coulthard
Nikki Fox
Rachele Dickie
Raj Mattoo
Mark Luke
terimeri dooriyan
Jack Aston
AndyC
Forum Stats:
Groups: 3
Forums: 24
Topics: 6221
Posts: 27285
Member Stats:
Guest Posters: 49
Members: 31908
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
