grand total

Dear Mr Excel - Please can you assist me. I have a pivot table where I have products shown with their market share calculated by using the "Show values as --> % of Grand Total" function on the pivot. My question is that when I deselect various products, this means that the true share changes...

I have a pivot table where I have entered a calculated field with Absolute Value: ABS(Forecast-Actual) The totals on each line are good but the grand total ignores the absolute value and sums the entire column as if it was not ABS. Example: <TABLE style="WIDTH: 147pt; BORDER-COLLAPSE...

Is there a way to show the row labels in an Excel 2010, Pivot Table Grand Total? For example, I have: sales for each SalesPerson and Month Peter Sales JAN: 15 FEB: 10 Susan JAN: 18 FEB: 12 Grand Total 55 I would...

Hi Guys, I need some serious help with sub-total function using VBA. Previously, I have raised this issue on this board and Peter_SSs has been really great help to sort it for me. His solution worked like a magic. Below I have attached three tables, which shows the previous version of the...

I created several pivot tables with calculated fields and it appears that , for those calculated fields, the Grand total value of these columns are different (sometimes lower sometimes higher) from the sum of each individual rows value.... :confused: Does someone had the same an issue and an...

I use a pivot table to summarise data in two columns: Actual and Budget. If "Grand Totals for Rows" under PivotTable Options is checked, the final column displays the sum of the two items for each row. Obviously, adding a budget figure to an actual is meaningless. However, if this column could...

Hello, I am trying to generate a top 10 list of revenue generating customers in a pivot table. The pivot table I have takes into account only the customers with the highest "Grand Total." Vertically listed are customers and horizontally listed are the last 13 months of revenue. I want to...