Go Premium for a chance to win a PS4. Enter to Win

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

Pivot help - calculated field

experts,

I have a query as a Pivot Table view.
I used the button "Auto Calc"
It summs as expected.

I need to add another column that shows the summ as a percent of the overall total.  
I can change the Auto Calc sum to "show as percent of Grand Total" but I also lose the subtotals.  

How can I add another column that will show the percent of the overall total but keep the subtotals?  

Pivot
0
pdvsa
Asked:
pdvsa
  • 3
  • 2
1 Solution
 
Phillip BurtonCommented:
Add a second, duplicate Amount field in your query (definitely named), and drag that into the "Drop Totals of Detail Fields Here", and change that one to %s.
0
 
pdvsaAuthor Commented:
Philip:  that seems to be pretty close.  I drag the [Amount] into the query as a duplicate field and gave it a name then I show the field list and drag this new duplicative field into the pivot and I can show it as Percent of Grand Total but the [Amount] is duplicated.  I have 2 columns that show [Amount] but in the duplicative column I do have a percent but just need to remove the duplicate [amount].    Not sure if you follow.
0
 
pdvsaAuthor Commented:
Pivot
0
 
Phillip BurtonCommented:
Move the date to the row field - it should then disappear.Access form
0
 
pdvsaAuthor Commented:
thank you Philip.  Have it working now...
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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