How to create dynamic dimension and expression using drill through drill down and hirercy ?

Hi Jayw

Thank you for reply my post.

For example if you look at the image i posted . 

i need the Dimension to be dynamic.

The Dimension i have Brand , Product Class , Product Type , Segment ETC

So user can start with selet YTD sales by Brand.

And user can click on Brand A or Brand B , for drill down.

and I can change the dimension to Product Class.

Paul Yeo