Forum

Notifications
Clear all

Inquiry about a function GetPivotData

2 Posts
2 Users
0 Reactions
63 Views
(@usb)
Posts: 244
Honorable Member
Topic starter
 
Hi, I have attached a file with a small report with 3 calculated columns.
How to pull with GetPivotData - data from a different column each time??
In cell G1 I made a drop-down list and I want the value to be updated accordingly - how do you do it?
 
 
Posted : 29/09/2022 4:03 am
(@debaser)
Posts: 836
Member Moderator
 

Amend the formula to:

=GETPIVOTDATA(""&G1,$A$1,"שנים",2016)

 
Posted : 30/09/2022 5:52 am
Share: