selected values in report
We have Material hierarchy variable (PRO_VAR) in BEx query I want to display selected product key values in report.
Below is the product data
I am using below formula to display its key values (in single cell)
It is displaying XYBISCUITS;XYDIARYMILK;XYCHOC
But i am expecting all key values like below (nospaces and restrict to 8 chars)
Could you please help me on this logic please..!!