Dears,
I have a list report based on cube. The columns are retailer type, product, quantity. Drill up/down is enabled.
When I drill down the Product for the row of blue....I want it to only drill down for the particular row(row with blue). That means the red rows will not get expanded. Is that doable? Thanks.
Retailer (by type) Products Quantity
------------------------- ------------ ---------------------
Department Store Products 17,957,330
Direct Marketing Products 2,564,202
Equipment Rental Store Products 1,254,301