powerpivot table

I need to make a calculated field inside the pivot table. The pivot table is linked to power pivot. The calculated field option in greyed out in the pivot table calculations tab. I have had no problems with this from a regular table to a pivot table. Any advice is appreciated - thanks...

Hi, I have created a Tickets table and a Dates table in powerpivot. When I add my "month" to the pivot table as a row label, there is an empty row at the end. I have quadrouple checked that I did not leave any blank rows in the dates table. Why would this be? I think it is preventing my Tickets...

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...

Hi all, I'm trying to find a way of creating a simple pivot that looks like this: <tbody> Fruit Sales Apples 3 Pears 5 Oranges 2 Total 10 </tbody> The data for each type of fruit is stored in a different table because each type of fruit has a lot of unique properties I...

I hope you guys can help with my issue. I have a large excel file that I need to use for weekly data analysis. Every week, new data is added and the possibility for old data to change is present (columns stay constant though). I cannot connect directly to the database source as far as I know...

I have the following table: Event Part_Number Month Year Date 10598 ADF345 1 2012 15/01/2012 10599 ADF345 1 2012 29/01/2012 10600 ADF345 2 2012 15/02/2012 10601 ADF345 2 2012 29/02/2012 10602 EFT689 1 2012 15/01/2012 10603 EFT689 2 2012 29/02/2012 10604 DBM165 1 2012 15/01/2012 10605 DBM165...

Hi There, My Question is "Is there any decent way, where i can amend and import data on an existing powerpivot table from multimple excel worksheet?" Background: I have started a large project in PowerPivot and got stuck in one silly problem. I have a a workbook with say about 36 worksheets...

I have tried several work arounds, PC's etc, checked all the forums, I'm at a loss. I have pasted an Excel table into PowerPivot table. When I add subsequent months of data, via Paste Append, (using the exact same format as the initial table) to the existing table, everything works fine. However...