Hi,
I have a report in SSRS with a subtotal that is totaling everything above it, but I need to subtotal only one item. Below is a simple example of what I am trying to do. I still want to see the details and I want one subtotal, in this case just the Orange. I have tried creating a Dataset with the value I am looking for and using it with the InScope Function but it keeps totaling everything. Any help would be greatly appreciated.
Currently
Product Name, Cost
Orange $1
Apple $2
Grapes $4
____________________
Subtotal $11
Goal:
______________________
Subtotal $3
Thanks
James