Row Count AFTER Filter has been applied.



    Is there a way to get a count of all the rows (total) after a filter has been applied at the row level?


    Ie. Revenue has 11 rows but once the 6 blank ones are filtered count the total number of rows. So it should return 5.

    Wednesday, May 07, 2008 6:10 PM


  • Apply filter at the group level and pass tha group name in th eRowNumber




    group by ID with following Filter


    =Expression -> Fields!ID.Value 

    Operator->           != 

    Value ->              Nothing


    To Display RowNumber


    Wednesday, May 07, 2008 7:38 PM