How to use bith max string and concat expressions in one dimention

[vanir88]

Hi All,

good day,

can you please help how to used below both conditions to use in single dimension., if use single condition it is working but if i combine both with "and " i am getting invalid Dimension. and i am giving this condision in Group dimension

Aggr(MaxString([Location]),[Industry])

and

aggr(Concat([Industry], ','), [Master Number])

the above contion is to get below scenario

Master  Number	Master Name	Contract Number	Location	Group
1137	EXOR	99698	Italy	Automotive,Comms & Media,Not Available,Utilities

[Satish3]

[image: image.png]

Like this one Output below table. Please help me

[rubenmarin]

I don't see any image.

If you want help you need to provide more info of what are you trying. Which result do you get? if there are differences it could be because your real data is different than the sample data provided