grand totals

Hello, I have a Pivot Table with Years as the top-level column, then two fields underneath, Cash and Operations. The values in each field are currently calculated as % of Parent Column Total, so Cash and Operations are shown as percentages of each year's total. I would like to also create a...

Here is picture of needed data. There is a piece of data (table 1). Primary data starts with March 2010 and I filtered it by Employee 1 and Employee 100. As you can see Employee 1 was not at the Project in May and December, so in May Total Expenses change was -$700. One part of my task is to...

For Sales Analysis, I use large pivot tables, based on transactional data. I want to be able to analyze everything in three dimensions: 1. Product: Product Group, Subgroup, Product 2. Geographical: Global, Continents, Countries 3. Time: Year, Quarter, Month I currently use the following set up...

Hello, I have a Pivot table in which I have Grand Total for rows as Sum. I want to add another Grand total with percentages BUT I need the percentages only in the Grand Total and not for each column within the table (Which seems to be the default). Any idea on how to solve this? Thanks, D

Hello all, I am using the following to create subtotals from a selection Range("B3:N1000").Select Selection.Subtotal GroupBy:=2, Function:=xlSum, _ TotalList:=Array(5, 6, 7) ActiveSheet.Outline.ShowLevels RowLevels:=2 I need to add a column with the sales percentage: the Net...

Hi: Imagine a medical clinic where there are, say, 5 doctors who each have their own list of patients. Every once in a while, though, one doctor will pitch in and see the patient of a colleague. Here is a sample set of data: Here's a pivot table that summarizes the data: So far, so good...

I need a grand total that sums the column. I have an if statement in my measure and the Grand Total is showing up as blank rather than summing the column. I know that sumx will usually work but I'm not sure where to put it here. Here is the formula...