Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Pivot Grand Total for Power Pivot not displaying correct

  1. #1
    New Member
    Join Date
    Nov 2017
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Pivot Grand Total for Power Pivot not displaying correct


    Pivot Grand Total for Power Pivot not displaying correct
    Hi


    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.


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


    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.

    Thanks

  2. #2
    MrExcel MVP
    Join Date
    Dec 2014
    Location
    Sydney, Australia
    Posts
    1,127
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot Grand Total for Power Pivot not displaying correct

    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.
    Matt Allington is a professional Power BI Consultant, Power BI Trainer and Microsoft MVP based in Sydney Australia. Matt is author of the Power BI book Supercharge Power BI and the Power Pivot Book Supercharge Excel.
    What is Power BI?

  3. #3
    New Member
    Join Date
    Nov 2017
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot Grand Total for Power Pivot not displaying correct

    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

  4. #4
    MrExcel MVP
    Join Date
    Dec 2014
    Location
    Sydney, Australia
    Posts
    1,127
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot Grand Total for Power Pivot not displaying correct

    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.
    Matt Allington is a professional Power BI Consultant, Power BI Trainer and Microsoft MVP based in Sydney Australia. Matt is author of the Power BI book Supercharge Power BI and the Power Pivot Book Supercharge Excel.
    What is Power BI?

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •