Report Builder - Row Total for multiple filtered datasets

[3treepoint]

Hi - I am using Report Builder to create a paginated report from multiple tables that have a filter on each dataset.  I need to display the total number of records for all row groups. I have a column that uses an expression to show RowNumber but I only want to display the last one.  Is there a better way to do this?  I cannot use Rowcount due to the dataset filters. 

[v-janeyg-msft]

Hi, @3treepoint 

What do you mean by 'display the last one' ? What does your visual look like?

[3treepoint]

I would like the last value at the bottom of the report to display (in the last column named Running Case Total), not the others above in the same column.  See image.

[3treepoint]

The expression is simply RowNumber(Nothing)

Is it possible to change the expression so the font and background are white on all row numbers except the last one?

[v-janeyg-msft]

@3treepoint  The code should be impossible to change the font color and background.

If you can add a index column and modify the expression like: when index=max index, RowNumber().

Best Regards,

Community Support Team _ Janey

[v-janeyg-msft]

@3treepoint 

It seems difficult, beacuse I am not good at writing report builder code, it is difficult to help you. Can you share your expression? If you can add some conditions to the expression, maybe it's possible. 

Best Regards,

Community Support Team _ Janey