Pivot Grand Total for Power Pivot not displaying correct

Ackermhc

New Member
Joined
Nov 28, 2017
Messages
2
Hi<o:p></o:p>


I have the following pivot table created from apower pivot table, linked to SQL data base. When I select the Grand Total (68) it does not display the 68 recordsbut instead opens the whole table related to the pivot table source. It wasworking fine before. <o:p></o:p>


ASC - Job State Age Period<o:p></o:p>
AOI Claimed<o:p></o:p>
1<o:p></o:p>
task_Org<o:p></o:p>
(Multiple Items)<o:p></o:p>
Count of Reference_Order_No<o:p></o:p>
Job_State<o:p></o:p>
JS_Period<o:p></o:p>
RFA<o:p></o:p>
EXE<o:p></o:p>
CDR<o:p></o:p>
CNR<o:p></o:p>
TND<o:p></o:p>
CANRE<o:p></o:p>
CAC<o:p></o:p>
Grand Total<o:p></o:p>
0-10<o:p></o:p>
34<o:p></o:p>
7<o:p></o:p>
3<o:p></o:p>
1<o:p></o:p>
1<o:p></o:p>
1<o:p></o:p>
47<o:p></o:p>
61-90<o:p></o:p>
1<o:p></o:p>
1<o:p></o:p>
11-20<o:p></o:p>
1<o:p></o:p>
1<o:p></o:p>
5<o:p></o:p>
1<o:p></o:p>
8<o:p></o:p>
21-30<o:p></o:p>
1<o:p></o:p>
2<o:p></o:p>
3<o:p></o:p>
31-45<o:p></o:p>
1<o:p></o:p>
1<o:p></o:p>
46-60<o:p></o:p>
1<o:p></o:p>
1<o:p></o:p>
2<o:p></o:p>
121-240<o:p></o:p>
1<o:p></o:p>
2<o:p></o:p>
3<o:p></o:p>
91-120<o:p></o:p>
1<o:p></o:p>
2<o:p></o:p>
3<o:p></o:p>
Grand Total<o:p></o:p>
36<o:p></o:p>
9<o:p></o:p>
1<o:p></o:p>
15<o:p></o:p>
1<o:p></o:p>
3<o:p></o:p>
3<o:p></o:p>
68<o:p></o:p>
<tbody> </tbody>

<o:p> </o:p>
I did another new Pivot, based on the samefiltering and it behaves the same, what do I need to set to only show thefiltered 68 records.<o:p></o:p>

Thanks<o:p></o:p>
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
Selecting the grand total should now show any records. Do you mean double click the grand total? When you double click a power pivot table, it doesn’t work the same as a regular pivot table.
 
Upvote 0
Hi Matt.
Thanks for the response.
Yes, when I double click on the 68 grand total it open the entire "source" table the pivot was built from with all teh records instead of just showing the 68 records. If this a Power Pivot behavior, is there a setting or configuration I can use to only display the 68 records when selected by double clicking on the pivot grand total.
Thanks
Cloete Ackermann
 
Upvote 0
Yes, unfortunately that is how it works. It is not very good. You can read my article here, but it is more work and certainly not as convenient as double clicking on the total. The procedure in my article should work in Excel too.
 
Upvote 0

Forum statistics

Threads
1,213,515
Messages
6,114,080
Members
448,548
Latest member
harryls

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