I have a simple SSRS tablix with two fields - Age Bracket and # of deaths per age bracket (for particular condition). The report is grouped by Age Bracket and # of deaths is count of records per Age Bracket.
I'm using the following formula for # of deaths:
CountRows("Age_Bracket")
Here is the tablix in design mode:
However, in Report Preview I see this (# of death appears multiple times per the same Age Bracket):
How to eliminate duplicates, so the report will appear like this?
