filtering data to get a sum

hello

I am trying to filtered data so that I can get a sum. For example, I have a report that just have two columns (see diagram). I want to add up all the share codes that are "1" and get one total so that when I run the report I'll get a total amount for each share code. I know that I can create a pivot table but I'm trying to eliminate that step and have the report manager do that.

The 2nd part of the report is to compare these share code to the GL number in SAGE. Any help is appreciated and I hope this made sense.

Thanks

Manny

Parents Reply
  • 0 in reply to manny99

    when you have 2 filters it defaults to "And". So if you have the 2 shrcode = 1, shrcode = 2 it will look for rows that have 1 AND 2.

    like this:

    you need to change it from "AND" to "OR".

    Right Click on the 2nd filter and select Properties.

    Check the Use "OR" Logic box and click OK.

    See what that does.

Children