Is there a function that can return many values?

[#1]

Hello,

I have created a chart that shows all orders that have resulted in more than one invoice.

I have dimensions that state:

=If(Aggr(Count(DISTINCT InvoiceNo),OrderNo) = 2, InvoiceNo)

My problem is that only one InvoiceNo is shown and I would like my chart to display the 2 InvoiceNo's that were used.

Is there a suitable function for this?

br

Martin

[Or · Accepted solution]

Sounds like you should be able to use the concat() function.

[johnw]

You could do this:

Dimension 1 = InvoiceNo
Dimension 2 = if(aggr(count(distinct InvoiceNo),OrderNo)=2,OrderNo)

Suppress dimension 2 when null, then hide dimension 2 if you really don't want to see what order numbers are associated with the invoices.