Insert columns to a cross table through multiple select listbox property control

[Vivek Varma]

Hi,

I have a cross table whose CELL VALUES are populated by adding columns through a property control (Multiple select Listbox), as per the user's selection. The horizontal and vertical columns are static.

$map("First($esc(${columnselect}))", ",")

While displaying the columns in the crosstable after selection though, the display name of the column also shows the aggregation (here:first), so it would show First(Capex 2018) rather than Capex 2018. How can we remove the aggregation while displaying in the crosstable.

 

 

Thanks in advance.

[Suraj Ullas 2]

Hey,

$map("First($esc(${columnselect}))", ",") as [${columnselect}] should solve your problem, Do let me know how it goes.

OK, I missed it you have a multiple select list, Let me check and get back to you.

 

Updated Answer:

Below expression should solve your problem, Let me know