• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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

Not open for further replies.
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)

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.00Formula to pickup subtotal (changes with slicer input) = 12.000.00 (Fields Should be zero when no products are below, but if additional product is selected should reflect new subtotal based on slicers)
Grand Total (From Pivot)6.0012.00

Pivot Table with No Slicers Active "Baseline"
Grand Total6.008.007.0011.007.0022.00


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.


For some reason You duplicated Your thread instead to move this to correct Forum.
This thread is closed now.
Not open for further replies.