Collapse Pivot Table row, Filter column, then expand row to show detail

[ILOVEJAVA]

Hi There,

This is my table and I need to compare prior period to current period for any location that has less than -40% change and greater than 50% over the prior period.

Emp ID	Location	hours	period
653521	A000101	80	201821
653521	A000101	30.22	201822
1115454	A000101	80	201821
1115454	A000101	15	201822
2514852	A000101	23.12	201821
2514852	A000101	80	201822
1458400	A000101	66.8	201821
1458400	A024531	15	201822
548408	A024531	60	201821
548408	A024531	13.2	201822
424014	A024531	83.09	201821
424014	A024531	22.4	201822
292967	A024531	79.88	201821
292967	A024531	10	201822
1820548	A024531	120	201821
1820548	A024531	40	201822
2568555	A024531	80	201821
2568555	A024531	9	201822
484996	A024531	14	201821
484996	A024531	80	201822
545567	A024531	14.08	201821
545567	A006471	35.1	201822
2468050	A008805	42	201821
2468050	A008805	61.45	201822
98443	A008805	11.5	201822
98443	A008320	11.5	201821
386793	A022553	10.65	201822
386793	A022553	38.65	201821
2850342	A022553	41.9	201822
2850342	A022553	38	201821
2282629	A022553	45.9	201822
2282629	A022553	12.4	201821
324737	A022553	80	201822
324737	A022553	40	201821
562941	A000986	78.4	201822
562941	A000986	83.05	201821
1108451	A006471	58.2	201822
1108451	A006471	51.6	201821
1125932	A006471	18.15	201822
1125932	A006471	24.7	201821

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

I created a pivot table and added a filter for <-40% and >50%. I need to collapse the data and look at locations that <-40% and >50% change over prior period, then I need to show detail under the filtered locations.

	Column Labels
	201821		201822		Total Sum of hours	Total Sum of hours2
Row Labels	Sum of hours	Sum of hours2	Sum of hours	Sum of hours2
A000101	249.92		125.22	-49.90%	375.14
653521	80		30.22	-62.23%	110.22
1115454	80		15	-81.25%	95
2514852	23.12		80	246.02%	103.12
1458400	66.8			#NULL!	66.8
A000986	83.05		78.4	-5.60%	161.45
562941	83.05		78.4	-5.60%	161.45
A006471	76.3		111.45	46.07%	187.75
545567			35.1		35.1
1108451	51.6		58.2	12.79%	109.8
1125932	24.7		18.15	-26.52%	42.85
A008320	11.5			#NULL!	11.5
98443	11.5			#NULL!	11.5
A008805	42		72.95	73.69%	114.95
2468050	42		61.45	46.31%	103.45
98443			11.5		11.5
A022553	129.05		178.45	38.28%	307.5
386793	38.65		10.65	-72.45%	49.3
2850342	38		41.9	10.26%	79.9
2282629	12.4		45.9	270.16%	58.3
324737	40		80	100.00%	120
A024531	451.05		189.6	-57.96%	640.65
1458400			15		15
548408	60		13.2	-78.00%	73.2
424014	83.09		22.4	-73.04%	105.49
292967	79.88		10	-87.48%	89.88
1820548	120		40	-66.67%	160
2568555	80		9	-88.75%	89
484996	14		80	471.43%	94
545567	14.08			#NULL!	14.08
Grand Total	1042.87		756.07	-27.50%	1798.94

<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

My data is upwards of 400 locations and 30,000 unique employees. This will need to be done each change in period, so weekly. I am in the process of recording a macro, so I hope it is a solution that I can record a macro for.

Any assistance you are able to provide is greatly appreciated. I look forward to your response.

Thank you,

ILOVEJAVA