Hi, my data is like below:
In details, I have two projects, A and B, and each project has its respective tasks.
My Goal: Display the Task that took longest to run.
What I want:
ProjectWhat I have (when i show the details)
[Max Duration] = Max([Duration]) in ([Project])
[Task Taking the Longest Duration] = [Task] where ([Duration] = [Max Duration])
ProjectWhat I get instead when i remove the detail columns Task and Duration:
ProjectPlease help, I do not understand why is it displaying #multivalue when all my other values are empty "".