I have a simple problem that I've solved a million times before, but that I've now forgotten how to. Basically I have a fact table; Accidents, and a detail table Drivers. The fact and detail tables are linked by a join table. Here is what it looks like as of now:
=If( [Driver Role] = 'Driver 1' , DriverId )
=If( [Driver Role] = 'Driver 2' , DriverId )
What I would like is for both drivers to be on the same row, giving me something like this:
Re: Table with multiple detail dims on the same row
I was hoping to avoid datamodel work since the solution puts the Driver on the fact table, when the user clicks a value in Driver1, it will remove other fact rows that don't contain that driver as Driver1. The way it currently stands with the DriverTable as a detail table, clicking the driver's name will bring in all accidents where they were Driver1 or Driver2.