+ Reply to Thread
Results 1 to 3 of 3

Grouping in powerpivot

  1. #1
    Forum Contributor
    Join Date
    09-30-2015
    Location
    LA my baby
    MS-Off Ver
    2013
    Posts
    727

    Grouping in powerpivot

    Hello. Grouping in pivot tables is fairly easy. However, grouping in powerpivot tables is much more tedious. You actually have to create the grouping table and then link. Is there any around this?

  2. #2
    Valued Forum Contributor
    Join Date
    12-02-2012
    Location
    Melbourne, VIC
    MS-Off Ver
    Excel 2016
    Posts
    750

    Re: Grouping in powerpivot

    ... wouldn't that be very handy when working with dates. Unfortunately, it seems "Grouping" is not supported in PowerPivot (not in Excel 2010 for sure). So, just as you mentioned, the approach to create a separate table and then define relationship/links with the data table seems to be the way.

    Let's see if other forum members advice of any other interesting ways to achieve this.

  3. #3
    Forum Contributor
    Join Date
    09-30-2015
    Location
    LA my baby
    MS-Off Ver
    2013
    Posts
    727

    Re: Grouping in powerpivot

    Oh well. Seems like powerpivot not so popular yet.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 12-10-2015, 08:24 AM
  2. Replies: 4
    Last Post: 07-23-2015, 03:35 PM
  3. Replies: 4
    Last Post: 07-26-2014, 02:35 AM
  4. Replies: 2
    Last Post: 06-02-2014, 09:34 AM
  5. Help with Dynamic Grouping to Subtotalling fields in PowerPivot Table
    By mikeTRON in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-12-2013, 01:10 PM
  6. Replies: 0
    Last Post: 11-20-2012, 05:34 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1