Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Can you try like below,
=Concat(DISTINCT{<[Financial Year]=,MonthShortName=,FiscalMonthKey={"$(='>=' & $(vSelYrMthStart) & '<=' & $(vSelYrMthEnd1))"}>} chr(39) & Account & chr(39),',')
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