Forum

Notifications
Clear all

Grand Total Calculated Field

2 Posts
2 Users
0 Reactions
84 Views
(@cgray)
Posts: 16
Eminent Member
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
(@mynda)
Posts: 4761
Member Admin
 

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
Share: