Grand Totals For Rows Not Displaying

Hello,
I'm pretty much a Pivot Table idiot, so I might be overlooking something
horribly obvious, but I'm trying to have a "Grand Average" column and row in
a Pivot Table instead of a "Grand Total." I see the Grand Total checkboxes
in the Options dialog box, but I've yet to stumble upon a way to specify a
function other than Sum.

Is this possible? If so, can someone let me know how?

Excel2000.

If I didn't explain that clearly enough, let me know and I can give an
example. Thanks for the help.

Mike

Hello - this seems simple but been searching for about an hour and can't figure it out. I have a simple pivot table with line items in the rows and months in the columns. I have grand totals turned on (annual number), but would like to move it to the left and for the life of me can't figure it out. I could do a calculated field and add the months but that seems like overkill. Any help is appreciated!

Sample:

Jan Feb Grand Total
a 10 10 20
b 10 10 20

Would like it to be:
Grand Total Jan Feb
a 20 10 10
b 20 10 10

can someone help me w this:
someone just sent me a pivot table that has rates by province and by month. the rows are by months and the columns are by province. each row and each column has a "Grand Total" at the end. im trying to figure out how the Grand Total is calculated, since it doesn't seem to be the sum or the average of the rates in that column. is there any way i can find the properties of the pivottable such that i can find out what is calculated at the Grand Total? thanks so much.

Hi,

I have a pivot table with a lastrow for grand total and lastcolumn for grand total. Now I need a code which selects only the data inside the table excluding both the row with grand total and column with grand total.

thanks buddy(s),
cheers

Hello,

I have created a pivot table and the Grand Total values are correct, except for 1 that keeps showing a value of 0%. My Grand Total row shows 3 sets of values...for 3 different months. Each month has the following:

Capacity | Availability | Total Availability %

I've used the calculated field function to calculate the Total Avail %...therefore, I've used "Avail / Cap" for each of the 3 months of data. In the Grand Total row, it calculates all information correctly, EXCEPT for the last row that shows a value of 0%. So the Grand total row looks kind of like this:

Grand Total | 761,292,745 | 229,221,558 | 30% | 786,669,228 | 244,528,458 | 31% | 1,547,961,973 | 473,750,016 | 0%


Can anyone out there help??

Thanks!!

Hi all,
I have one issue when i get the data through the pivot table
option. after creating a pivot table, i enabled the sub-total and the
grand total in the pivot table properties. after enabling that the
sub-total and the grand total columns appear as #VALUE!.

I have office 2003 in OS 2000 proffesion.

Please help me

Regards
Yazh

Hi all,
I have one issue when i get the data through the pivot table
option. after creating a pivot table, i enabled the sub-total and the
grand total in the pivot table properties. after enabling that the
sub-total and the grand total columns appear as #VALUE!.

I have office 2003 in OS 2000 proffesion.

Please help me

Regards
Yazh

Hi,

In Excel 2003, I hid the grand total column. How do I unhide the total? In "Table Options", the "Grand totals for columns" is checked.

Thanks,

Chris Wood

Hi there - i have a pivot table, created using MS Excel 2000, that looks
like this:



Prod: Widgit



Area..Territory...200412..200501..200502

01.......01-01.......100.....100.....100

...........01-02.......100.....100.....100

01 Total..............200.....200.....200

02.......02-01.......300.....300.....300

...........02-02.......400.....400.....400

02 Total.............700.....700.....700

GRAND TTL.......900.....900.....900



what i would like to show is % CONTRIBUTION FOR EACH TERRITORY based on
their AREA, not the % of GRAND TTL.



What i am trying to produce would look like this:



Prod: Widgit



Area...Territory...200412..200501..200502

01....01-01.........50%......50%.....50%

.........01-02.........50%......50%.....50%

01 Total...........100%.....100%.....100%

02....02-01.........43%......43%......43%

.........02-02.........57%......57%......57%

02 Total...........100%.....100%.....100%



When I use the "% of column" function in the Field Settings, it calculates
the individual territory % contribution against the GRAND TOTAL, so i get
something like this:



Prod: Widgit



Area..Territory..200412..200501..200502

01.....01-01.......11%.....11%....11%

..........01-02.......11%.....11%....11%

01 Total............22%.....22%....22%

02....02-01........33%.....33%....33%

.........02-02........44%.....44%....44%

02 Total............78%.....78%....78%

GRAND TTL......100%....100%...100%



the only way i can figure to do this is to create separate pivot tables for
each different AREA...using AREA as the PAGE FIELD and selecting SHOW ALL
PAGES...then it works...



but what i would like is ONE table, on ONE page which shows % Contribution
of each TERR to the AREA...



i was hoping for a one-stop solution - without having to adjust my
database...



is this do-able ?? appreciate your assistance!

Please, Is there anybody that knows how to calculate in pivot table, % on grand total column only, not all of cells
type1 type2 type3 type4 Grand Total
agent1 4 4
agent2 1 5 129 135
agent3 6 5 9 904 924
agent4 6 1 3 87 97
Grand Total 12 7 17 1124 1160

Thaks a lot

Hey guys,

I'm working with a pivot table with many different names in the leftmost column. "Grand Total" is one of the columns and I want to do a vlookup so it will look up the name in the left most column and find the column that says "Grand Total," and return to me the value in that respective column.

Reason for me wanting to do this is that I want to be able to choose multiple weeks based on the month of data I want to analyze so the column number that "Grand Total" is actually under will change constantly.

Thanks!

Hello All,
I have an Excel 2007 (2003 compatible) workbook that creates a pivot table and chart/graph from data linked on a network share drive. I would like to have the Grand Total rows data show up in the graph title which I can do well with a vlookup and concatenate on the daily totals. The problem occurs when someone clicks the macro to show the data monthly versus daily as another column is added to the pivot and the column source in the vlookup no longer applies.

Example:
Code:

=VLOOKUP("Grand Total",$A$10:$B$3000,2,0)

This gives me the daily Grand Total which I can then place in the graph.

When the monthly button is pressed and the pivot table changes, a new column is added with months and column 2 is now blank and the Grand Total data is in column 3.

I believe an array with index and match may work but I am not sure. Is there a way to find Grand Total in column A and look across that row for the first non-blank value, regarless of how large or small the pivot table is?

Thanks,
wolf

Hello,

I have created a pivot table ... naturally, there will be a Grand Total at the bottom of it. I applied a filter to show the top 10 customers. Automatically, the grand total will change to show sum of the top 10 customers only.

what I am trying to do is this:

Applying the filter without effecting the grand total ... I want to the grand total of all customers even after applying the filter. Is that possible?

Thnnx

Hi,

Thanks for all your help previously - i have yet another question

I have a pivot table with grand totals at the end. due to the structure of other formulas referencing that pivot table, i cant use a "grand total for rows" option.

However, i would like to sum the values in the "Grand total for columns" row - however, as i choose different options in the pivot table, that row can move up or down.

How can i use a dynamic cell reference to sum the values in this row?
thanks!

I generated a pivot table using financial data for clients/by year/by sales rep. The table successfully calculated the Individual totals by rep by year as well as the grand totals by rep and by year. The only grand total it did not calculate is the overall grand total by client. I know I can simply generate a sum field/cell manually, but am unable to label that column as the grand total. How can I get this grand total to calculate and have it become part of the pivot table itself?

Thank you.

Hello,

I have a very simple pivot table that shows me the sales volume of different stores (in the rows) for the months (Jan, Feb, Mar - in the columns). The table also shows me the Grand Total of Volumes for Jan, Feb, Mar, which I want to display as well. My goal now is to have an extra column at the end that puts a $ Value to the Volume of the Grand Total, using prices I have in my source data (different for each store). I have tried to just calculate the $ figures in my source data and then show it but this always ends up showing for every single month. However, I only want the $ figure for the sum of Jan, Feb, Mar. And that does not work.

Two solutions I came up with ( but did not work, maybe you have an idea):
1) I do add an extra column in the source data and somehow tell the pivot table to show only the grand total of that column summed up over the months.

2) I have a price list in my source data and using the grand total of the volume, i insert a calculated field that multiplies volumes and price.


Both did not work. I hope I explained the problem well enoguh and you can help me.

Cheers

Hello, here is what my data looks like in the pivot

---------------Jan -- Feb -- Mar -- Grand total
Frank Boss
--------- Bob --10 -- 15 --- 20 ------45
--------- Jen -- 15 -- 60 --- 10 ------ 85
--------- Bill -- 20 -- 12 --- 55 -------87
Frank Boss Total 45 -- 87 --- 85 ------ 217


I want to be able to have the grand total column to show averages. The problem is that when I change it to averages, the other columns of data like Jan - Bob - 10, changes to averages from "sums". Is there a way to change the grand total column independant of the other columns? Or any other way around this? The goal would be to have the main data on the pivot to "sum" and have the grand total "avg".


Thanks,
Jared

Hello,

i have a pivot table showing sales per month then sum the 6 month into a grand total column, now i need also to have an everage sales as another summary beside the grand total by dividing this grand total by 6 , how can i do that?
i know i can do it outside the pivot but i want it inside in case users change the pivot lauout or change number of displayed monthly sales , then the this average sales i want to add will divide grand total sum by number of months displaged

can this be done?!

Thank you
Bassam

Hi
Is there a method to obtain a subtraction instead of a Grand Total at the end of the pivot table report. In example below to show B-A or A-B instead of A+B. Appreciate any help. Thankyou
Sum of Sales Company Month A B Grand Total Jan 2312 2342 4654 Feb 435 234 669 Grand Total 2747 2576 5323

I have Excel 2007. I have a pivot table. The grand total is adding all columns. Can I change it so it only adds certain columns.

Sheet1

B C D E F 2 Add Add 3 Book Car Bike Computer Grand Total 4 1 2 3 4 4

Excel tables to the web >> Excel Jeanie HTML 4
I would like to add book and bike. It is not an option to exclude the ones that are not being added from the report. They need to remain on the report. The grand total field is called 'sum of amount'. The columns are called 'Item'.