Removing Grand totals from Query PivotTable

[ScottBeatty]

Sorry for being redundant; I saw a post earlier about this but I had a hard time finding it.

To keep it short and sweet, my query set up is: Employee, Team Name, and then I have the same field in the column as I do in the data and it presents pass/fail data. I have the data shown as a percent of the row so that there is a success rate shown but I want to remove the grand totals from the rows because it is obviously going to be 100% every time and it's unnecessary.

Thanks for looking!

Scott

 

[billmeye]

You can change the visible property to false and it will not show. Or, you can delete the field all together as long as it does not cause problems elsewhere.

 

[ScottBeatty]

Okay thank you. How exactly would I be able to change the visible propery though?

 

[billmeye]

I was assuming you were using a Report and in the design view of the report you can select each control and in the Properties you will find Visible where you can change it to Yes or No. But, if you are just talking about viewing your query results, in the query design view there is a checkbox called Show: for including or not including the column.

 

[ScottBeatty]

Well I don't have a column that I created to calculate the totals. They are just provided automatically and I was wondering if there was a way to just show the percentages of passes and percentages of fails and not have them totaled to 100%

 

[billmeye]

Sorry I couldn't help, I'm not familiar with the new version of Access and automatic anything.

 

[way2bord]

oddly enough, you just change this in the ribbon. There's a menu item in the HOME tab - Under Records section. (sigma) Totals. Just click it.

 

[ScottBeatty]

yep that's what I was trying. However, I'm primarily using this for the PivotTable and it is disabled when I open it as PivotTable. I tried to click in after switching to viewing to different views but it didn't change anything. Any other suggestions on what may work?

 

[way2bord]

yep that's what I was trying. However, I'm primarily using this for the PivotTable and it is disabled when I open it as PivotTable. I tried to click in after switching to viewing to different views but it didn't change anything. Any other suggestions on what may work?

Are you subtotaling any of the fields?

edit: right click each column and unselect SubTotal.

 

[ScottBeatty]

That button is also disabled when I right click.

 

[way2bord]

Are you right-clicking specifically on the header? It should highlight all fields associated.

 

[ScottBeatty]

well that certainly got rid of the grand total, but then for the success and failing rates it just yields a value of #N/A. I may just keep it with the grand total at this point haha. It doesn't necessarily affect my database. I just found it a little redundant

 

[ScottBeatty]

thank you for all of your help!

 

[way2bord]

Access can be a bit finicky. Consider dropping the whole thing into a continuous form to manipulate appearances. Good luck!