Drill down on one column

[antmoe3]

I have a main report with the columns
COL-A COL-C COL-D
34 $450 $500
Each row has a unique value.


When I drill down I would like for the data to show as
COL-A COL-B COL-C COL-D
34 34-A $200 $250
34 34-B $250 $250

In the drill down, COL-B will have a least to additional rows of data. How do I do this?

 

[lbass]

Place your fields in the detail section and then insert a group on Col-A. Then right click on the detail amounts and insert summaries at the group level and drag them into the group header. Then go to the section expert and hide the detail section. Right click on the Col-B label->format field->suppress->x+2 and enter:

drilldowngrouplevel = 0

-LB