Sum Visiable Values Only

M

Mark Jackson

Hello,

I have a report with the "Hide Duplicates" set on one field. Is it possible
to sum only the values that are showing and not the duplicates in this field?
Thanks in advance for your help.

Mark
 
D

Duane Hookom

You could create a group header on the "hide" field and use a Running Sum on
the value in the group header.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple IF Statement in Word 5
Is this possible? 0
Report Sum with Multiple Relationships 2
Summing Field in Report 1
Split form 0
MS Project Center-Autolink column fields 0
Insert Multiple Fields without Dialog closing between each... 0
Duplicate entry in a column/row 14

Top