Error in Grand Total field in Pivot Table

Guinaba

Board Regular
Joined
Sep 19, 2018
Messages
235
Office Version
  1. 2016
Platform
  1. Windows
Hi guys,

I have this Pivot Table, created from PowerPivot, where I'd like to see in the Grand Total field the average of all the dates. Not sure the reason but the Value Field Settings is disable, so I cannot summarize the Grand Total column. I manually created the Total AVG just to show the correct values.

Any idea how can I have the use Total AVG using the Pivot Table, reminding that it is from the data model (PowerPivot).


1737368780520.png



Correct AVG
Customer4/11/2024 11/11/2024 18/11/202425/11/20242/12/2024 9/12/2024 16/12/202423/12/202430/12/2024Grand TotalTotal Average
Customer A 100% 100% 100%100%
Customer B100% 100%100%
Customer C52%52%56%42%21% 61%23% 34%44%
Customer D42%-49%-6%18%21%53%-22%30%-39%18%5%
Customer E-12%-20%33%49%12%38%42%-45%-85%17%1%
Customer F29%56%75%-8%-36%-26%-25%-52%-131%12%-13%
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
Sir, this option become disabled when we use a measure in a pivot table i.e take a measure created in power pivot and drag to the value area of the pivot table but if we use a field that was already part of the data table or a calculated one calculated using DAX then these options work
 
Upvote 0
Sir, this option become disabled when we use a measure in a pivot table i.e take a measure created in power pivot and drag to the value area of the pivot table but if we use a field that was already part of the data table or a calculated one calculated using DAX then these options work
Thanks @Zulkifal Shahzad, would you know how to create this measure using DAX?
 
Upvote 0
would you know how to create this measure using DAX?
Yes sir i know how to create this. If you really want to learn DAX completely i will suggest you to visit youtube channel "Excel is fun" "MSPTDA" videos playlist. Still if you need my help i am here to help you
 
Upvote 0

Forum statistics

Threads
1,226,267
Messages
6,189,940
Members
453,583
Latest member
Ok_category1816

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top