{"id":312,"date":"2018-02-14T06:10:31","date_gmt":"2018-02-14T06:10:31","guid":{"rendered":"https:\/\/career0to1.wordpress.com\/?p=312"},"modified":"2018-02-15T05:54:25","modified_gmt":"2018-02-15T05:54:25","slug":"excel-power-pivot","status":"publish","type":"post","link":"https:\/\/career0to1.com\/?p=312","title":{"rendered":"Excel – Power Pivot"},"content":{"rendered":"

1. Convert to table and name the name, as following example named as “Products” Table<\/p>\n

\"pp1\"
\n2. Excel options -> Add-ins ->Manage -> COM Add-ins-> Go -> turn on the powerpivot
\n\"pp2\"
\n3. Powerpivot -> Add to Data Model for all of the tables
\n4. Powerpivot -> Manage ->Diagram view -> connect the relationship
\n\"pp3\"
\n5. Powerpivot -> Manage ->Data view -> pivot table
\nThe same process as simple pivot table<\/p>\n<\/div><\/div>","protected":false},"excerpt":{"rendered":"

1. Convert to table and name the name, as following example named as “Products” Table 2. Excel options -> Add-ins ->Manage -> COM Add-ins-> Go -> turn on the powerpivot 3. Powerpivot -> Add to Data Model for all of the tables 4. Powerpivot -> Manage ->Diagram view -> connect …<\/p>\n","protected":false},"author":2,"featured_media":316,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[5],"tags":[9],"_links":{"self":[{"href":"https:\/\/career0to1.com\/index.php?rest_route=\/wp\/v2\/posts\/312"}],"collection":[{"href":"https:\/\/career0to1.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/career0to1.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/career0to1.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/career0to1.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=312"}],"version-history":[{"count":1,"href":"https:\/\/career0to1.com\/index.php?rest_route=\/wp\/v2\/posts\/312\/revisions"}],"predecessor-version":[{"id":435,"href":"https:\/\/career0to1.com\/index.php?rest_route=\/wp\/v2\/posts\/312\/revisions\/435"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/career0to1.com\/index.php?rest_route=\/wp\/v2\/media\/316"}],"wp:attachment":[{"href":"https:\/\/career0to1.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=312"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/career0to1.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=312"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/career0to1.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}