Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
i would like to show data in a text box according to a condition.
The condition would be similiar to:
Show Product where Start-Date is minimum AND Plant = "A".
Therefore i would like to see the Product where the Start-Date is the nearest in a specific plant.
In the settings i can find only an editor where i can put in a measurement.
Thank you for your support.
Perhaps this
If([Start-Date]=Min(TOTAL [Start-Date]) and Plant='A', Product)
Or
If([Start-Date]=Min(TOTAL [Start-Date]) and Plant='A', Concat(Distinct Product, ','))