Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Hi @Anuhyak1 ,
You can replace the "Sub Brand" dimension with the following expression as dimension:
=If(GetSelectedCount([Org Division])=1,[Material Desc],
[Sub Brand])
Hi @Anuhyak1 ,
You can replace the "Sub Brand" dimension with the following expression as dimension:
=If(GetSelectedCount([Org Division])=1,[Material Desc],
[Sub Brand])
Thanks
But how to change the labels of those two fields.Subbrand label change to material description.
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')