Forum Discussion

Copper Contributor

Jun 01, 2024

Pivot table average

Hi everyone. I want to Hi everyone. I want to calculate average as 116,803,158.95, but pivot table displays as 3,899,938.53. Why is there a difference between them? How could I fix it? thanks.

excel

cchildaa

Copper Contributor

Jun 02, 2024

Thanks for your help. However, if I do not have power pivot in my excel version, what could I do? Many thanks.

SergeiBaklan

Diamond Contributor

Jun 02, 2024

cchildaa

I could be wrong, but based on you screenshot

you are on Excel desktop for Windows.

Power Pivot add-in is still available for download for Excel 2010 Download Microsoft® SQL Server® 2012 SP1 PowerPivot for Microsoft Excel® 2010 from Official Microsoft Download Center, I guess for Excel 2013 it exists as well. Starting from Excel 2016 Power Pivot is built-in, the only it shall be activated in Options. In general only data model is required, measures could be created without Power Pivot.

However, if you are on Android, Mac or web - Power Pivot is not available.

Perhaps something could be done with VBA if to use cached PivotTable, but I'm not sure.

If nothing of above is available, perhaps to use some other tools/formulae in addition or instead of PivotTable.