SSRS custom subtotal

Former Member
Former Member $organization

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 

Orange               $1 

Apple                   $2 

Orange                $1 

____________________

Subtotal              $11 

 

Goal:

Product Name, Cost

Orange              $1 

Apple                  $2 

Grapes               $4 

Orange               $1 

Apple                   $2 

Orange                  $1 

______________________

Subtotal              $3

 

Thanks

James