Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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