Hi experts, I just start to use this awesome wonder called PowerPivot. I've been a regular user of Pivot Table. I am not sure if my question is a simple one. Here it goes. I have two Lookup Tables: Date Table and Factory Table (only consist of factory codes and their corresponding names). In the...
Goodday,
I want to use the SUMX function in combination with DISTINCT (PowerPivot + Excel 2010).
For example I have this data:
<tbody>
Productgroup
Product
Sales
Group Y
product1
5
Group Y
product2
4
Group X
product1
5
Group X
product3
3
</tbody>
Products can be assigned to multiple...
I'm looking to set up a calculated field in a pivot table that shows the variance to the column total; similar to the show values as % of Column Total option in value field settings, however it has to be a calculated field and is just the straight variance.
I understand that you cannot...
Hi,
i have a list in sharepoint which acts as my datasource for the application am working on, i can get data feed (OData) in the browser but when i try to import the data in powerpivot model it fails with the below error message. Please help me fix it.
============================
Error...
I am new to power pivot, I am trying to create a measure to calculate distinct customers buying per month where the total sales for the month and grand total are greater than 0.
eg. Customer A buys in July 1000 units count would be 1, in august a credit is raised for 1000 units august count =...
Hey Guys,
For simplicity sake lets assume I have this table of data: Name, Full Date, Month #, count (always equals 1)
Each record in the table counts as 1 error.
What I'm trying to do is get a YTD average for the number of errors in the table per Name?
In excel, I could simply do a SUMIF...
Hi,
I have create a Power PivotTable (2010) with sales data from each month from 2011 - today. From the PivotTable I have created a PivotChart.
I only want to see sales data from the last 13 months in my chart so i have created a report filter for that. However, I would also like to see a 12...
Hi All,
I'm using excel 2010 with power pivot and like to create a new calculated column to allocate an amount to set of groups based on the no of distinct products in the group. I have uploaded the sample data here in the link below and if you can help me how I can get the same results in the...
Hello.
I have [Total Wgt] and [Total Wgt Last Year].
Got the difference/variance by: Variance Wgt Against LY:=[Total Wgt]-[Total Wgt Last Year]
If Total Wgt is 2000 and Total Wgt Last Year is 5000, i expect -3000 as a result. But it's only giving me 0.
Is there additional formula i have to...
hi Folks
Still stuck on this one. I've posted a file with what I have and with what I want. I'm currently using Powerpivot so want to do it that way...Have a chart of accounts and set of balances for 3 groups - PTD/YTD for each item.
I want to generate a gross profit figure that will appear...
hi Folks
I have a Powerpivot project with the following:
Chart of Accounts:
LinkID (unique field - text - text checked in Excel and Powerpivot)
Category
Classification
Company
Description
Company 1 Trial balance
LinkID (link for Chart of accounts) also checked to be text in Excel and...
Hi..one of my user was unable to get the data.The test connection is successful but its getting 0 rows eventually. While people using the same datafeeds are able to get the data. Can any one help me how can I troubleshoot?
Its powerpivot 2010 and 32 bit software !
I am using PowerPivot tool to load the data from a feed.But I am getting weird error like
Error in high-level relational engine.The following exception occured while the managed IDb Command interface was being used:The remote server returned an error:(500) Internal server error.. An error...
Hi all
I was wondering if someone could give me some help. I have to find the average number of call per day and per hour.
My Data looks like follows ( small sample - there are roughly 700 calls per day). I also have the hour the call was taken. I am using Excel 2010. I was wondering if I...
Hey Guys,
This might seem kind of strange, but I'll explain.....I currently have an Excel sheet with 100k+ rows of data (and growing) and 32 columns. I currently use Pivot tables to create reports and summarize the data (Reason I use Pivots is because users like to drill down into the data)...
Hi all. How is it possible to show an average of the values in a column, in a pivot chart, in Excel 2010? I want to be able to show an average line through the bars in a pivot bar chart displaying ratios calculated from two fields.
The actual worksheet deals with a power pivot, and therefore...
I'm creating a PowerPivot (2010) for teams in my org to use that will show them their complete portfolio of investments. There are multiple ways a team can be associated with an investment (i.e. funding, managing, supporting). I would like to use slicers to allow users to specify which...
I have a GIS application that has a very limited reporting engine. One thing that it can do is download a customized data extract into Excel.
On a one-off basis, I can take the Excel file from the GIS to create all of the custom reports and filtering that I need. However, I need to be able to...
I have a spreadsheet with columns labeled with Dept #, position titles, headcount and number of terms and the turnover % for a specific period of time. When I slice the data by depts, my turnover % is not accurate because my only options from the pivot table are to sum, average, min, max or...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.