Pivot grand total for rows not showing

[Barto]

Hi,

I cannot get the row totals to show on my pivot chart.

Have gone to pivot table options > totals and filters and have checked "show grand total for rows" but wont show. I can get the column totals to to hide ans show by checking anf unchecking the "show grand total for columns" but not matter howm many times i try checking and unchecking and refreshing etc the row total will not show.

Anyone had this problem before and know how to fix?

 

[NumberJumble]

I finally was able to add the grand totals for the rows. I never figured out how to do it using the Insert Pivot Table function from the ribbon - that is still a mystery to me.

Instead, I used the Pivot table Wizard (apparently the old wizard that is hidden in the product). It was this wizard that was used in the video I was trying to follow along with, so I Googled where to find it and added it to my quick access toolbar.

Using the Pivot Table Wizard:
In step one I selected Multiple Consolidation Ranges
In step two I selected I will create the page fields
In step 2b I only selected the range
In step 3 either option

The result was a pivot table that looked like my original table but with Grand Totals for the Columns AND Rows.

I needed this in order to be able to double-click on the intersecting grand totals to get a differently formatted table.

Hooray, I have what I wanted!

 

[Pascale France27]

I finally was able to add the grand totals for the rows. I never figured out how to do it using the Insert Pivot Table function from the ribbon - that is still a mystery to me.

Instead, I used the Pivot table Wizard (apparently the old wizard that is hidden in the product). It was this wizard that was used in the video I was trying to follow along with, so I Googled where to find it and added it to my quick access toolbar.

Using the Pivot Table Wizard:
In step one I selected Multiple Consolidation Ranges
In step two I selected I will create the page fields
In step 2b I only selected the range
In step 3 either option

The result was a pivot table that looked like my original table but with Grand Totals for the Columns AND Rows.

I needed this in order to be able to double-click on the intersecting grand totals to get a differently formatted table.

Hooray, I have what I wanted!

Hooray for me too
Thank you very much
I use your methode too, and it is great (I spend half the afternoon seeking for solving the Total for rows that was not showing in Excel 2007)
As you mentionned , I viewed the video explaining that ALT+D+P launch the old wizard... that perfectly works
thanks thanks thanks too much

 

[abudanial]

I have the same problem. I am trying to follow a Youtube video which describes how I can convert Column Data Fields to Row Data Fields https://www.youtube.com/watch?v=-mzpLg1gI98.

The described solution depends on me being able to click on the cell where the Grand Totals for the rows and columns intersect (the cell on the bottom right of the table). The example in the video is shown using the Excel 2003 wizard. Using Excel 2013 I haven't been able to get my pivot table to display the Grand Totals for Rows. In the Ribbon under Design - Grand Totals I can toggle the grand total for the columns on and off, but the toggle for Rows does nothing. I've tried using a very basic test table containing 5 columns labeled Location, Q1, Q2, Q3 and Q4. In the Location column I entered names of countries. In the other columns I entered simple numbers which are formatted as numbers. I tried formatting them as currency with the same effect. Each of the Q1-Q4 columns has a Grand Total, but the rows do not. Grand totals for rows is enabled in the Pivot table options.

I am getting frantic because I really need to get the result shown in the video If anyone knows a solution I would be very grateful.

Believe me I registered to this forum to reply to you, not sure though whether you got the answer already.

In latest excel version we can still bring the pivot table wizard. keep the cursor (active cell) anywhere in your data and press ALT + D and then P - this will bring the pivot tables wizerd. Follow along as it is there in the video you mentioned and you can see GrandTotal and by clicking the intersection you will get the data as rows.

Hope this will be useful for you of anyone like us who's frantically searching.

 

[Hmerman]

I know you found your answer but another way to do this is to create a `Calculated Field` that SUMS the Pivot Columns you need.

1] Click > `PivotTable Tools` > `Options` tab > `Calculations` section > `Fields, Items & Sets` > Choose `Calculated Field` from list.

2] Give your Calculated Field a `Name` and in the `Formula` textbox type the SUM Function and insert the Columns or Fields you want to sum from the `Fields` listbox: `=SUM(Field1,Field2,ect)`.

3] Click Add and there you go.

 

[nikt]

Hi,

I cannot get the row totals to show on my pivot chart.

Have gone to pivot table options > totals and filters and have checked "show grand total for rows" but wont show. I can get the column totals to to hide ans show by checking anf unchecking the "show grand total for columns" but not matter howm many times i try checking and unchecking and refreshing etc the row total will not show.

Anyone had this problem before and know how to fix?


----->

stupid excel, when you have different columns it calculates totals only if you have a field in the columns section.

To do the calculation you can create a calculated field, in Office 365 select the table then:

1-Analyze--> fields, values, sets
2-insert the sum formula using the fields reported in the box. Click ok
3-A new field pops up in the pivot table fields (right tab)
4-drag and drop in pivot table

cheers

D