Drill down functionality in straight table

[Anuhyak1]

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

When user selects Org Division it further drill down to Subrand but in the Subbrand column it need to display Material description.

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
Material Desc

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

Ex: IT Cosmetics is selected it drill down to YSBB CC CREAM which is Subbrand and in the Subbrand column it should display corresponding Material description (JT Simmer)

[joseph_morales · Accepted solution]

Hi @Anuhyak1 ,

You can replace the "Sub Brand" dimension with the following expression as dimension:

=If(GetSelectedCount([Org Division])=1,[Material Desc],
[Sub Brand])

[Anuhyak1]

Thanks

[Anuhyak1]

But how to change the labels of those two fields.Subbrand label change to material description.

[joseph_morales]

Hi @Anuhyak1,

You must put a similar expression but as text strings in the dimension label.

=If(GetSelectedCount([Org Division])=1,'Material Desc',
'Sub Brand')