Collapse some fields in drill down.

See more:

SSRS

SSRS-2008

Hi,

I have a below requirement in Drill down report. we have below two values under Lost Customers.

Lost Customers
Number of lost customers
Rate%

Here I need to implement , where I always need to show Number of lost customers
and implement drill down in only Rate. I mean, Number of lost customers should show always, but If we click on plus (+)symbol which is in Load Customers, Rate should expand.

here Number of lost customer and Rate are the two values under column Subgroup and Lost customer under column Group. In our design pane only Group and subgroup shows, not values. Now how to show one value of Subgroup column always and another value only when we click on + symbol. I have attache the screen shot as well.

Please suggest me How to achieve this in SSRS?

What I have tried:

Grouping I have done, but not able to hide any particular value and show others. All three are in my dataset. Lost customer is in 1st column and other 2 Number of lost customer and Rate fields in another column. If I apply drill down both will hide or both will display. But my requirements is I need to show Number of lost customers always and Rate should appear only when we click on + symbol which is in Load customer.