Need to add a filter in Report Builder at a Group Level

  • I need to add a filter at a group level in Report Builder (Ad Hoc Reporting) in SSRS

    I have a Sales attribute and Total Sales is the corresponding aggregate field.

    I am creating a report of Total Sales by Territory. I want to add a filter for Total Sales > $200,000 at the Territory Level, not individual Sale Level.

    When add a filter on Total Sales in the filter screen, it doesn't work at the desired level.

    How can I add at the Territory level and also when I enhance this report to Country/Territory level?

  • Sandeep - Did U find a fix for the issue you had initiated. I am having the same issue in Report Builder. The filter is always doing a record level check even if i build the filter using Total (Agg func.). I would aprpeciate if you could post the solution (if any) you found.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply