Excel 2019 - "Artificial" Grand Total Row on Top of Pivot / Slicers

[SeveralTradesLater]

Hi Smart Folks, new member here.

I have a file with a fairly lengthy Pivot Table and Slicers I want to add a "artificial" grand total row on top of the pivot.

I am currently using =iferror(getpivotdata) to capture to grandtotals from the bottom of the pivot, but it doesn't adjust with the slicers and doesn't align with the products.

Please kindly suggest solutions.

Thank you.

Incorrect view with =Iferror(getpivotdata) - Current

"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

 

[vletm]

SeveralTradesLater​

You, new member, has opened new thread to Excel Challenges -forum - it's okay.
But ... as You've read there, those should be as written:
Post an Excel related Challenge for others to Solve (You must have a solution) Don't post questions here!
Please, check again - to which Forum Your thread belongs?
An other thing, a sample Excel-file, You would get quicker and better replies.

 

[vletm]

SeveralTradesLater​

For some reason You duplicated Your thread instead to move this to correct Forum.

"Artificial" Grand Total Row Above Pivot that aligns with "units"/column values when slicers are used.

Hi Smart Folks, new member here. I have a file with a fairly lengthy Pivot Table and Slicers I want to add a "artificial" grand total row on top of the pivot. I am currently using =iferror(getpivotdata) to capture to grandtotals from the bottom of the pivot, but it doesn't adjust with the...

chandoo.org

This thread is closed now.