Dynamically change the label columns based on condition in straight table

[Anuhyak1]

I have Org Division and Sub brand value columns in Straight table

Ex:If one Org Division value is selected, the columns will change to report the following:
Sub Brand
and Subbrand Column drill to Material Desc

if >1 Org Divisions are in selection criteria, table will show as-is (Org Div, Sub Brand). 

If  user drill down to Sub Brand or if user select Sub Brand the columns should change to Sub Brand and material desc. How to  implement these 3 changes in dimension label?

[rubenmarin · Accepted solution]

Hi, below the dimensions box there is a box to enable conditional dimensions.

Add both fields as dimensions: Sub Brand and Material Desc

- Condition for Sub Brand can be: GetPossibleCount([Org Division])>1

- Condition for Material Desc can be: GetPossibleCount([Org Division])=1

So only one dimension is enabled and it shold work as the drill down.