Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
=concat( if(aggr(sum(Quantity),Spoint,Date)>30, Date), ', ')
Try like
=concat({<Quantity={">30"}>}DISTINCT Date,', ')
=concat( if(aggr(sum(Quantity),Spoint,Date)>30, Date), ', ')
Hi
Try this expression:
=concat ( IF( aggr ( (sum(Quantity)),Spoint,Date)>30,Date),',')
Also, see the Attachment.
Hope that helps.
Regards
Aviral Nag
Hi
Concat(Aggr(If(Sum(Quantity) > 30, Date), Date, Spoint), ', ')
HTH
Jonathan