Hi
If I have a 3 dimension "Transport No." (show the transport No.) , "Route" (shows the route of the transport No), "Reload" (show the transport no. that a transport is reloaded with)
Now I am interested to see the route for the reloaded transport (because o course there is also a route for this transport no) - and I dont have a dimension for this.
Can I make a formula so it will show this or is there any smart easy way to do this?
10 answers
Basically, in the data source, you will duplicate the file/table and join it in the appropriate field. in your case, you would join the Transport No field to the Reload field. The Left outer join would return all the Transport No and the matching Reloads. Does this make sense?
