Solved

Pivot table help - dont sum

Posted on 2014-12-09
2
97 Views
Last Modified: 2014-12-09
Experts, I have a pivot in access.  I do not want the Pro Rata to summ as it is doing in the far right.  How do I keep it from summing?  You can see the one on the left does not summ but when I drag to the right it summs it.  

please see pic

thanks

Pivot
0
Comment
Question by:pdvsa
2 Comments
 
LVL 34

Accepted Solution

by:
PatHartman earned 500 total points
ID: 40489509
I am using A2013 which no longer supports pivots so I can't give you exact instructions.  Go back to the wizard and rebuild the query.  You should be able to uncheck the summing option.
0
 

Author Comment

by:pdvsa
ID: 40490151
thats no good that they are going to do away with that.  

thank you for the help.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now