# grand totals

1. ### Pivot Table: Calculating Average % Across Years

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...
2. ### DAX Formulas (wrong grand totals and missing values)

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...
3. ### Multi Dimensional Subtotals for Grand Totals in Pivot Table

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...
4. ### Pivot Grand Total Sum & %

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
5. ### Creating % of Grand Total for Selection.Subtotal formula

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...
6. ### Pivot Tables - Comparing Grand Totals to each other

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...
7. ### Grand Total not summing PowerPivot measure column

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

### We've detected that you are using an adblocker.

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.

### Which adblocker are you using?

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

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