aggr expression

[#1]

Hi Experts,

I have a table which looks like the sample attached.

Sheet ‘Actual data’ is the raw data.

I have to make a pivot table like in sheet ‘Required data’

Each Product ID has multiple Delivery ID and multiple vehicle ID (with order no)

I have to exclude the vehicle ID with order = 0.

Also I have to bring one row of Vehicle ID per product code

I tried the below expression to bring all vehicle id in one cell. But I couldn’t exclude vehicle ID with order = 0

aggr(Concat(distinct [Vehicle ID],', '),ProdCode,DeliveryID)

Can someone please help me with expression..?

[kaushiknsolanki · Accepted solution]

Hi,

Try this,

Concat({<Order = {">0"}>}distinct [Vehicle ID],', ')

Regards,

Kaushik Solanki

[sunny_talwar]

Is order an expression? May be this:

Concat({<[Vehicle ID] = {"=Count(OrderID) = 0"}>} DISTINCT [Vehicle ID], ', ')

I assumed that your Order is a expression -> Count(OrderID). Replace Count(OrderID) with your actual expression in the above expression