+ Reply to Thread
Results 1 to 3 of 3

Can not group after adding tables in Power Pivot data model

  1. 11-23-2021, 11:44 PM #1
    lastnn30
    lastnn30 is offline
    Forum Contributor
    Join Date
    04-09-2013
    Location
    City, World
    MS-Off Ver
    Office 365
    Posts
    248

    Can not group after adding tables in Power Pivot data model

    Hi
    I have 2 tables and I added them to Power Pivot data model. I created a link and then loaded the both tables to Pivot table, everything is fine. I have Age column in one table, so I tried to move the Age field as Rows box in pivot table, and excel listed me all the ages but when I tried to click on any of these values (ages) and then click on Group. I got error message saying I can not group them. Does that mean we can not group any field if tables are connecting in Data Model of Pivot table? Please see attached excel file. Thank you very much.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-24-2021, 02:00 AM #2
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Can not group after adding tables in Power Pivot data model

    Quote Originally Posted by lastnn30 View Post
    Does that mean we can not group any field if tables are connecting in Data Model of Pivot table?
    Unfortunately, yes. You cannot perform that action for Pivot Tables which are connected to the Data Model.

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/
    Reply With QuoteRegister To Reply
  3. 11-24-2021, 05:30 PM #3
    lastnn30
    lastnn30 is offline
    Forum Contributor
    Join Date
    04-09-2013
    Location
    City, World
    MS-Off Ver
    Office 365
    Posts
    248

    Re: Can not group after adding tables in Power Pivot data model

    Thank you.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. power Pivot data model question
    By Poconosms1 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-08-2021, 10:09 AM
  2. Power Pivot - filter in the data model does not apply itself into the pivot table
    By apoje in forum Excel General
    Replies: 3
    Last Post: 07-12-2019, 06:17 AM
  3. Power Pivot Data Model Error
    By MarkZang in forum Excel General
    Replies: 0
    Last Post: 01-31-2018, 11:51 AM
  4. Creating a Pivot Table from Power Pivot Data Model?
    By nobodyukno in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2017, 12:02 PM
  5. [SOLVED] Power Pivot and Data Model theory
    By BDD2015 in forum Excel General
    Replies: 9
    Last Post: 11-04-2016, 09:45 PM
  6. power pivot table - Data model
    By pccamara in forum Excel General
    Replies: 2
    Last Post: 04-18-2016, 11:20 AM
  7. adding a calculated field to power pivot data model
    By stephme55 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-26-2016, 07:13 PM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1