Pivot Table Challenge - Subtotals Above Pivot Table + Slicers

[SeveralTradesLater]

Hi everyone,

Encountering a bit of a new challenge today. I inherited a file with a fairly lengthy Pivot Table with Slicers so we are adding a "artificial" grand total row on top of the pivot.

We are currently using =iferror(getpivotdata) to capture to grandtotals from the pivot, but it doesn't "move" with the slicers and doesn't align with the products.

Please kindly let me know what formula can I use to capture the desired state below?

Greatly appreciated.

Thank you.

Incorrect view with =Iferror(getpivotdata)

"Artificial" Grand Total with Iferror(Getpivotdata)

0.00

0.00.

7.00

0.00

0.00

Desired State - Assumed there are many slicer fields not shown.

Example: Products Selected in Slicer (Banana and Strawberries + FY17+19)

Grand Total (Above Artificial)	Formula to Pickup Subtotal (Changes with Slicer Input) = 6.00	Formula to pickup subtotal (changes with slicer input) = 12.00	0.00 (Fields Should be zero when no products are below, but if additional product is selected should reflect new subtotal based on slicers)	0.00	0.00	0.00
	Banana	Strawberries
FY17	5.00	2.00
FY19	1.00	10.00
Grand Total (From Pivot)	6.00	12.00

Pivot Table with No Slicers Active "Baseline"

	Apple	Orange	Banana	Peach	Kiwi	Strawberries
FY17	1.00	2.00	5.00	7.00	1.00	2.00
FY18	2.00	2.00	1.00	2.00	5.00	10.00
FY19	3.00	4.00	1.00	2.00	1.00	10.00
Grand Total	6.00	8.00	7.00	11.00	7.00	22.00

 

[SeveralTradesLater]

Been looking up examples online for hours. Can't seem to find the right approach. Should I be using index match? Any assistance would be greatly appreciated as I am still learning.

 

[SeveralTradesLater]

I created a new sample screenshots with different values from the thread, but essentially the same scenario. When I click the unit slicer the fields no longer align. The two values should be directly to the left 2200 should be on top of DEF Paid (Cell B1) 69000 DEF PO (C1). Unfortunately I am unable to use XL2BB until I get my own computer. Any assistance would be greatly appreciated. Thank you.

 

[SeveralTradesLater]

Resolved! Talking to myself here, but don't want someone else spending time on this when others might need help.