powerpivot excel2013

I converted a pivot table into formula (kept one copy of the pivot table as backup), but when I update or refresh all, it does not display new rows (although the original pivot do) why, how do I get it to work?

Hello, firstly, Hello to all - I am new to the fourm. I hope someone can help me, I have a model that has two tables for Forecast (Labour and Non-Labour) The issue I have is that I would like to be able to view the data in one field in the pivot table. at the moment I have them as. e.g...

I have multiple tables of sales data orgainzed by sales channel. For each row of data, there are over 70 fields with either categorization of the products or data related to the sale - volume, revenue, ad spend, commissions, etc.... Here is my challenge boiled down to two of the tables for...

Hi, I have created a power pivot table as shown in the picture. I want to calculate quarter over quarter sales change. For which I have to divide for example corporate family "Acer" 's sales in 2012Q4 by sum of all the corporate family. I am using measure to do this. But I am not sure what...

Hello, could anyone help me with the below problem; I have a table which includes the 'length of stay' (how many days someone has received the service). I want to pull this data month by month into a powerpivot chart and show the average. For some reason it wont work it out, it 'counts' the...

When I in a totally fresh workbook try to Add table to PowerPivot Data model, I get these errors: Microsoft Excel We couldn't load the Data Model. This may be because the Data Model in this workbook is damaged. and PowerPivot for Excel PowerPivot is unable to load the Data Model Any ideas...