Forum Discussion
Transit Time Benchmark
Hi All, I am trying to create a dashboard which compares actual Transit time against a benchmark transit time per lane. Actual Transit time from Kobe to Los Angeles, CA= 18 days Benchmark T...
I figured it out. Silly mistake. I forgot to set the cross filter direction to both
Hey so I tried that, but the relationship is not simply one to one.
Many origins can go to one Port of arrival. Tokyo to LAX, Nansha to LAX, PASIR GUDANG to LAX, etc. Because of this, the LOOKUPLVALUE function will not work.
Below is a screenshot of what i have.
I figured it out. Silly mistake. I forgot to set the cross filter direction to both