Grand Total Based On A Field

I need to display a grand total both full total and a total based on the value of another displayed field.  For example, I have a report that looks something like this:
Salesman	Sales Amt	Phone Sales?
Joe Bleaux  123,456.00	    N
Jane Doe     54,756.24      Y
Fred Mertz   91,876.00      N

Sales Total 260,088.24
Phone Sales  54,756.24

Open in new window

How do I do this (and hopefully be able to display the total on the report header)

LVL 10
Who is Participating?
Kurt ReinhardtConnect With a Mentor Sr. Business Intelligence Consultant/ArchitectCommented:
For the Grand Total, simply right-click the Sales Amt field and choose Insert Summary.  Place the Summary in the Report Header or Foot

For the Phone Sales Total, create a formula that evaluates the Phone Sales Value:

  {table.phonesales} = 'Y'

Add this field to the detail section of the report and then right-click it to Insert Summary and place summary in either the Report Header or Footer..  Remove from report once you've created the summary.

ClifAuthor Commented:
That did it.

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.