Sum of Group Formula

I have a formula at the "Description" group level "NewVaue".  I want to put the formual in a pivot table.  It sums all the record details which is not what I want it to do. I just want the sum for the totals for the group level the formula is in.  "Description".

Please help.  Thanks!
evendAsked:
Who is Participating?
 
James0628Connect With a Mentor Commented:
Of course the best solution would be if you could change the tables/joins and eliminate the duplicate records.  Failing that, do you get two records for _every_ detail, or just some of them?  Is it _always_ two records?

 If you always get two of every record, that means that your summaries would be doubled, so one brute force approach (for Sum) would be to create a formula that divided a field in half and use that formula in your cross-tab.  FWIW, for a regular report summary (not in a cross-tab), you could do the same thing, or do a summary on the field and then create a formula that divided the summary in half and use that formula to display the summary on the report.

 James
0
 
mlmccCommented:
Group level formulas only work in the group.

WHere is the pivot table?

mlmcc
0
 
evendAuthor Commented:
I have it at the report header.
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
mlmccCommented:
There are no groups at that point.

Have you tried using a cross tab?

mlmcc
0
 
evendAuthor Commented:
I have in a crosstab at report header level.  Because when you view the details I get two lines for each record it distorts the totals. I have played with joins and selected disctinct records option and can not cure the two lines for one record issue.  I have been rolling the data up to groups when needed.

Sorry early on I said Pivot I meant to say Crosstab.
0
 
mlmccCommented:
Can you upload the report?

mlmcc
0
 
evendAuthor Commented:
Thanks not ideal but worked.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.