Reference Pivot Table Column in Formula

[jessebh2003]

I have a pivot table and need to summarize the findings using formulas without cell references but have been unsuccessful finding information on how to reference a column in a pivot table. The formulas will go into a summary table. Each year, the previous year's data will be added. The pivot table has one row for each video (294 videos) and the source data has an entry for each time someone watched the video (9344 rows).

Summary Table

	Total % Watched Average	Total Views	Total Modules
	=/> 90%	< 10
2020​
2021​
2022​

Pivot Table Data

	Total % Watched Avg		Total Sum of Watch Time (hh:mm:ss)		Total Views
Row Labels	2020	2021	2020	2021	2020	2021
1 - Introduction to POCUS and DVT Ultrasound Video Recording		27.960%​		2:05:07​		9​
2 - Lung/Pleural Ultrasound Video Recording		27.557%​		3:11:28​		11​
2020 CIN Town Hall Videos - June 2020	41.972%​		1:38:09​		4​
21st Century Cures Act Town Hall		7.080%​		0:02:55​		1​
3 - Cardiac Ultrasound Video Recording		9.789%​		0:49:51​		10​
4 - Abdominal Ultrasound Video Recording		21.851%​		0:51:29​		5​
5 - Procedural Ultrasound Video Recording		16.131%​		1:26:26​		12​

For the Total % Watched Avg columns, I'm trying to count the number of times the value is equal to or greater than 90% for that specific year. I started with this

=COUNTIF(GETPIVOTDATA("Total % Watched Avg",PivotTable!$A$2,"Case Title","1 - Introduction to POCUS and DVT Ultrasound Video Recording","Years",2020),">=90%")

But when I try to select the column, it changes to this

=COUNTIFS(PivotTable!B5:B298,">=90%")

For the Total Views columns, I'm trying to count the number of times the value is less than 10. I started with this

=countif(GETPIVOTDATA("Total Views",PivotTable!$A$2,"Case Title","1 - Introduction to POCUS and DVT Ultrasound Video Recording","Years",2021),"<10")

But when I try to select the column, it changes to this

=COUNTIF(PivotTable!F5:F298,"<10")

Pivot tables are not my forte and any help or suggestions would be greatly appreciated. (Note: I tried using the XL2BB add-on but it keeps freezing Excel so I was unable to use it to paste the data above.) Thanks!!