Concat dates with condition

[Anonymous]

Good day!

In attached model i calculate in one pivot table sum(quantity by Spoints), in second - concat dates where sum(quantity)>30

But result is wrong.

Expected result:

Spoint1: 23-09-2014, 25-09-2014

Spoint2: 22-09-2014, 23-09-2014, 24-09-2014, 25-09-2014

Thanks!

[senpradip007]

Try like

=concat({<Quantity={">30"}>}DISTINCT Date,', ')

[maxgro · Accepted solution]

=concat( if(aggr(sum(Quantity),Spoint,Date)>30, Date), ', ')

[aveeeeeee7en]

Hi

Try this expression:

=concat ( IF( aggr ( (sum(Quantity)),Spoint,Date)>30,Date),',')

Also, see the Attachment.

Hope that helps.

Regards

Aviral Nag

[jonathandienst]

Hi

Concat(Aggr(If(Sum(Quantity) > 30, Date), Date, Spoint), ', ')

HTH

Jonathan