[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 106
  • Last Modified:

Pivot table help - dont sum

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
pdvsa
Asked:
pdvsa
1 Solution
 
PatHartmanCommented:
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
 
pdvsaProject financeAuthor Commented:
thats no good that they are going to do away with that.  

thank you for the help.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now