I’m re-posting question. I’m using excel pivot table to browse a cube, for example the adventuresworks example. I drag dimension ‘Product Categories’
and ‘Sales Territory’ to Row Labels area, a date dimension to column, and any measure to Values area. Now I only want to expand ‘Europe’ under ‘Bikes’, but the excel
will expand ‘Europe’ under every ‘Product Categories’, is there any way to avoid that? In visual studio it works fine.
View Complete Post