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
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
Add a comment