Forum

Notifications
Clear all

Hiding Fields in a Pivot Chart

2 Posts
2 Users
0 Reactions
139 Views
(@matt-flynn)
Posts: 10
Eminent Member
Topic starter
 

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.

 
Posted : 06/08/2022 11:04 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Matt,

It depends on your file structure. Please upload a sample file that illustrates the issue and your desired result.

Mynda

 
Posted : 06/08/2022 7:03 pm
Share: