PowerPivot is a data mashup and data exploration tool based on xVelocity in-memory technologies providing analytical performance to process billions of rows at the speed of thought.

learn more… | top users | synonyms

0
votes
0answers
14 views

MS Excel: Send Data from PowerView to PowerPivot

I have an Excel workbook with two sheets: a PowerView sheet and a PowerPivot sheet. They both show the same data; the PowerView sheet shows data at a high level, and the PowerPivot allows users to ...
0
votes
0answers
21 views

calculated column in pivot table from power pivot

From SQL server I have a query that gives me daily transaction numbers for few companies per day, something like DATE Company Total Tax year 2013-04-24 ABC 50 2013 ...
2
votes
1answer
26 views

Auto formatting new pivot rows to data bars

I have a pivot table that takes data from database and displays it as a data bars. Problem is, that the data is updated daily - every day new row is added so the pivot table is growing. Unfortunately ...
0
votes
2answers
270 views

Excel 2013 PowerPivot add-in crashes Windows 7

Running into a serious problem with little help on solving the issue. Any time I try doing anything with DAX or sometimes just opening Excel application, Excel crashes and gives me the following ...
0
votes
0answers
75 views

Listing/grouping variables in pivot table field list

I have data with 60+ variables and I would like to group the variables into different collapsible fields in pivot table similar to having different tables in the pivot field list instead of having all ...
1
vote
1answer
43 views

Import from Folder data source missing from PowerPivot

If I look around on the Internet, I see people have the ability to import all files from a given folder: ...
0
votes
0answers
54 views

Does MSOLAP.5 automatically ship when the Power Pivot addin is installed

We have been getting the following error on some user's PCs when they are trying to connect to Analysis Services OLAP cubes: XML for Analysis parser: The restriction value provided by the ...
0
votes
1answer
26 views

Getting #NUM! for outer nests of IF statement division

I have some sales figures for which I have values in pounds, units, and dollars. From PowerPivot, I'm creating a pivot with Periods columns (Current Week, MTD, QTD, YTD) and sub-columns of "Measure" ...
0
votes
0answers
49 views

Why is my excel 2013 pivot table not sorting properly on % differnce

I have a pivot with the following: Categories running down the rows Columns with a count in for each category for each quarter last year, say number of jobs in each category for each quarter. When ...
3
votes
3answers
5k views

Excel 2010 PowerPivot: How to show items with no data?

In standard Excel pivot tables, there is an option for fields that allow you to force display of all items even if there are no results for your current selection. Here's the option: However, using ...
1
vote
1answer
195 views

Data Source Credentials issue with Excel PowerPivot

I am using Excel 2010 with PowerPivot. I am trying to go to the Query Editor. When I click on Table Properties, I get a password prompt: The problem is that I don't know the password and when I ...
0
votes
0answers
79 views

Calculating Annualized Turnover in Excel PowerPivot

Can someone please help me formulate this as a Dax expression? This is an extension of the problem here: calculating-annualized-turnover-in-a-pivot-table-or-powerpivot In this version I need to ...
0
votes
2answers
690 views

PowerPivot Bar is grayed out

I'm trying to begin learning to use adding measures in PowerPivot but the PowerPivot Ribbon is pretty much all grayed out. Can you tell what I did wrong? How do I get the rest of the selections on the ...
0
votes
1answer
258 views

Calculating Annualized Turnover in a Pivot Table or PowerPivot

I'm trying to calculate employee turnover where the numerator is annualized only for the current incomplete year. The closest I have gotten is TER/HC as a calculated Field in a pivot table. This ...
2
votes
1answer
181 views

How should I share workbooks that use PowerPivot?

I've used powerpivot to make a super-awesome report. But now I need to share it with my co-workers, who do not use powerpivot. When I send someone a powerpivot report to users without powerpivot ...
0
votes
0answers
29 views

Display filtered PowerPivot table in Excel

Using a large PowerPivot table as my source, I'd like to create a table for an end-user report that displays a slice of the data. So if my PowerPivot table contains box office returns for movies in ...
0
votes
0answers
186 views

Select Perspectives when creating a pivot table from a Power Pivot model

I've created a Power Pivot data model, and set up a number of perspectives. I know these can be used to filter the available fields when the data is accessed through other systems, but is there a way ...
-2
votes
1answer
381 views

Merging data tables to form one master table

I have multiple sheets containing a table each which I want to merge to form a master table sheet. I also need this master sheet to be updated automatically incase we make any changes to the tables ...
1
vote
0answers
27 views

Powerpivot will not install

I am trying to install 64 bit Powerpivot on a 64 bit Excel 2010 platform on a Windows 7 64 bit machine. I get an error message saying Excel 2010 must be present first, even though it already is. ...
0
votes
2answers
517 views

PowerPivot for Excel 2010 not installing on Office 2010 Home And Business

I'm trying to install Microsoft PowerPivot on a machine with a full Office 2010 Home and Student installation, and I'm not able to get the installation to work properly. The COM library will not ...
0
votes
0answers
95 views

PowerPivot Set Advanced Properties Database connection

I'm currently working w/ MS PowerPivot for Excel connecting to an ORACLE Database However I'm having trouble connecting to a new database. I can go into the advanced settings, change the source ...
1
vote
0answers
235 views

How to display non-hierarchical attributes on same row using Excel Powerpivot?

Using an Excel 2013 ProPlus PowerPivot pivot table, I have the following: (+ indicating a drill-down point) +Attribute-1 +Attribute-2 Attribute-3 Attribute-4 Below is what I would like to ...
1
vote
0answers
201 views

PowerPivot data feed error “Semicolon expected” during import

When importing data from an atom feed in PowerPivot, I get the following error: XML parsing failed at line 7, column 727: Semicolon expected. The feed currently only returns two entries, and ...
0
votes
1answer
674 views

How to group count by week date in PowerPivot

I have a table of data in PowerPivot connected to a sharepoint list. Each row has a date that I need to group by week and count the rows in that week. Is there a DAX formula or other approach to ...
0
votes
1answer
73 views

How to convert and Excel formula to a PowerPivot formula?

I need to convert this Excel sheet formula to an PowerPivot formula: =IF(D3=0,"NA",B3/D3) B3 = F5 D3 = F13 Need to add the IF to this formula: =SUM('data'[F5]) / SUM('data'[F13]) How can I do ...
1
vote
0answers
169 views

PowerPivot - Your beta software has expired

I'm running the 32-bit version of Excel 2010 on Windows 7 64. I've downloaded the 32-bit version of PowerPivot from here however I get the following error: Now I can see what the error message is ...
1
vote
1answer
225 views

How can you improve an Excel workbook that leverages PowerPivot

I have an Excel workbook that has 30 plus pivot tables and 10 plus slicers connected to PowerPivot. When we filter data based on these slicers the performance is sub par, 30 sec to 2 minutes. Is ...
1
vote
1answer
621 views

Excel PivotTable % of a specific value

My users have a hand built report showing tickets by time frame and their priorities. Priority Count 1 68 2 41 3 61 N/a ...