summary help

[Former Member]

Hi Team,

I have data like this.

Name                orders

AAA                       22

BBB                       1

CCC                       3

DDD                       4

Now I don't want show AAA in report.Show I suppressed it.

And now when I apply sum it should not add in summary .I should get 8 only

but I am getting it in summary too.I need to do it in report level only.

Please suggest the logic

[abhilash_kumar · Accepted solution]

Hi Prasad,

Go to Report > Selection Formulas > Record and add this code:

{Table.Name} <> 'AAA'

This will filter out records where Name = 'AAA' and the summary should work fine as well.

If you don't want to remove the records, you can create a Running Total.

Expand Field Explorer > Right-click Running Totals > New.

Choose 'Orders' as the Field to Summarize.

Choose 'Sum' as the Sum function.

Under 'Evaluate' choose, 'use a formula' and click the formula button beside it. Use this code :

{Table.Name} <> 'AAA'

Drag and drop this Running Total on the Report Footer.

-Abhilash