Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
84
Views
Topic starter
Hello,
Is there anyway to get the grand total to work correctly for a calculated field in a Pivot Table?
Posted : 27/09/2019 4:29 pm
Hi,
If it's not returning the desired result, (maybe you're averaging the data), but it's likely a limitation of calculated columns in regular PivotTables. The solution is to use Power Pivot where you have access to DAX measures that are far more flexible.
Mynda
Posted : 27/09/2019 6:44 pm