Share via

GROUP not work in PIVOT table with data source data model

Anonymous
2018-02-28T13:26:44+00:00

hello 

I'm using Microsoft office 365 and I have a problem with GROUP in pivot table especially when I use external data source as data model I get the message like this cannot group that selection, but when I use the normal way ( without external data) it's  work fine.

I know this message comes if data is text, not number or content especial character, but as I said it's work fine without connecting pivot table with external data source as data model

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Ashish Mathur 100.9K Reputation points Volunteer Moderator
    2018-02-28T23:16:47+00:00

    Hi,

    The Grouping feature on a Pivot Table created via the Data Model is deactivated.

    1 person found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-02-28T17:28:52+00:00

    Hi Haitham,

    PivotTables are a great way to summarize, analyze, explore, and present your data. For the Pivot data grouping issue that you're experiencing, we suggest posting your issue to our MSDN forum directly for proper assistance to resolve your concern.

    Let us know if you have other queries.

    0 comments
  2. Anonymous
    2018-02-28T19:54:44+00:00

    MSDN forum is not suitable because it's for SQL server and my question on  Excel

    0 comments