Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    386
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Power pivot 2010

    I'm looking into working with PowerPivot for 2010. I importe the files but was unsuccessful in creating the report that I wanted. The attached has the report with the tab named EXAMPLE and the other tabs are the samples of the imported reports.

    If anyone has some idea how to get a pivot table report to look like the EXAMPLE report, that would be great.

    Thanks
    Attached Files Attached Files

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Do you have PowerQuery available? It would be much easier to get PQ to merge your tables and then use that as the source for either PowerPivot or just a regular pivot table since you aren't doing anything complicated here.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    386
    Thanks
    3
    Thanked 0 Times in 0 Posts
    I do not have POWER QUERY but I will need a report so is POWER QUERY going to give me this. I'm working in MS OFFICE 2010.

    Thanks

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    If you have Office 2010 Professional Plus, you should be able to use PQ. You can review the system requirements and download it (free) here: https://www.microsoft.com/en-gb/down....aspx?id=39379

    If you can't use PQ, we can certainly come up with some code to do it.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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