Dynamic Grand-total with lists and multi-value parameters
Basically I've created a list that subtotals according to the group.
I then created a multi-value parameter that allows the user to choose which group is shown in the report.
How can I get the grand total to refl开发者_运维知识库ect the parameter since its currently outside of the list?
To have your grand total reflect the parameter, you could place it in a one-row table (with no header/footer). Group by the same expression as your list, then filter the table by your parameter:
=Fields!YourField.Value = Parameter.YourParam.Value(0)
Finally have your grand total field, in the table, use the expression =CountRows()
to get the correct number.
Hope this helps! --Dubs
精彩评论