+ Reply to Thread
Results 1 to 4 of 4

PowerPivot

  1. #1
    Forum Contributor
    Join Date
    06-05-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    109

    PowerPivot

    Hi all,

    I'm taking a real huge step to explore about this PowerPivot function.
    My company is using Excel 2010 and just install the add-on of PowerPivot
    And what's next? I got a big chunk data in Excel 2010, how to utilize this PowerPivot?
    If it's Pivotable, it's straightforward, by highlight all the cell I want and press Insert PivotTable, and that's where all the push and pull fields the way I want

    But with PowerPivot, I struggle to move next step.
    Googled around to find the most user-friendly and easiest to understand, but still stuck...

    Any expert can give some guidance?

    Thanks
    cks1026

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: PowerPivot

    Hi,

    Simplest introduction is to make your data into a Table first then on the PowerPivot tab you can create a linked table. Once you have done that you can create a pivot table from the Power Pivot data using the Power Pivot tab again rather than the default Excel pivot table option.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Forum Contributor
    Join Date
    06-05-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    109

    Re: PowerPivot

    Question...

    For normal Pivot Table, we create the pivot table based on the raw data, which we can view the raw data at a specific spreadsheet.
    What about PowerPivot? I mean I try to play around, once I created the PowerPivot Window, that's where the PowerPivot pops up
    Where does this PowerPivot raw data saved at? and how can we trace back the PowerPivot raw data?

  4. #4
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: PowerPivot

    You may view all the source data tables in the Power Pivot window.

+ 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. Powerpivot
    By clairh2011 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 06-29-2016, 04:59 AM
  2. Help with PowerPivot DAX
    By SebastianColombia in forum Excel General
    Replies: 0
    Last Post: 02-19-2016, 11:37 AM
  3. Replies: 4
    Last Post: 07-23-2015, 03:35 PM
  4. PowerPivot
    By ethelp in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-16-2014, 06:49 PM
  5. Replies: 2
    Last Post: 06-02-2014, 09:34 AM
  6. PowerPivot and KPI's
    By Curious2 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-03-2013, 12:33 AM
  7. 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