Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sounds like you should be able to use the concat() function.
Sounds like you should be able to use the concat() function.
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.