Exclude unwanted values from calculated dimension

[arockiyaselvana]

Hi all,

I am trying to show the combinations only in the below screenshot. But I am getting the individual Product names also. Please help to advise how to exclude the same.

Code used in the calculated Dimension: =aggr(Concat(DISTINCT ProductName,'+',ProductName), OrderID)

where Blue highlighted values are individual product name that I don't want to show and Red colored value is the one I want to show.

Please let me know if any other details required.

Thanks in advance.

- Arockiya

[arockiyaselvana]

I am able to remove the Individual Product name using WildMatch() as all the combinations having '+' sign.

Code:=If(Wildmatch(aggr(Concat(DISTINCT ProductName,'+',ProductName), OrderID),'*+*')=1,aggr(Concat(DISTINCT ProductName,'+',ProductName), OrderID))

[PrashantSangle]

Hi,

Try like

if(count(Aggr(Distinct ProductName,OrderId))>1,aggr(Concat(DISTINCT ProductName,'+',ProductName), OrderID))

Regards

[arockiyaselvana · Accepted solution]

Hi Max,

Thanks a lot for your time and reply.

However, when I tried the above code, I am getting "Allocation Memory exceeded" Error. Any idea why we getting this error in Calculated Dimension. But I am able to proceed with above code in my reply.

Thanks and Regards,

Arockiya