I have a following drill down report that displays Customer by tier and then products that each customer is assigned to

+Tier 1

   + Customer 1      

       Ticket#  ProblemDescription1  Product1  Version1

       Ticker#  ProblemDescription2  Product1  Version2

       Ticket#  ProblemDescription3  Product2  Version2

       Ticket#  Problem Description4 Product1  Version2

Now I wanted to generate a report in SSRS to show for Customer1 how many tickets are related to combination of  (Product 1 & Version 1)  and How tickets are for (Product 1 & Version2)

I read about CountDistinct() but that will just give me a unique count is there a way to accomplis the above.

Your help is highly appreciated

Thanks in Advance

Vasim