How to concatenate strings for grouped columns and Direct fields in straight table for YTD.

[Anonymous]

Hi,

How to concatenate strings for grouped columns and Direct fields in straight table for YTD.

Example Expression that i am using for concatenate is:

Concat(DISTINCT{<[Financial Year]=,MonthShortName=,FiscalMonthKey={"$(='>=' & $(vSelYrMthStart) & '<=' & $(vSelYrMthEnd1))"}>}Account,',')

Here Account is my grouping column

Please help on the above issue.

[devarasu07]

Hi,

Can you try like below,

=Concat(DISTINCT{<[Financial Year]=,MonthShortName=,FiscalMonthKey={"$(='>=' & $(vSelYrMthStart) & '<=' & $(vSelYrMthEnd1))"}>} chr(39) & Account & chr(39),',')

[sunny_talwar]

What is the issue that you are having? Is the above expression not working? Are you using this as a dimension? If that is what you are doing, you will need to use Aggr() function to make it work as a dimension