Drill Down with different datasets
I know there are some threads around this but none of them seem to touch on the issue I'm having.
I have the top card built off Dataset A with columns for Regional Manager, District Manager and Locations. Dataset A summarizes different revenue streams for each location. The card is subtotaled by Regional Manager then has the District Manager listed followed by Locations then all the different revenue.
Dataset B has the details of all the revenue streams from Dataset A including (character for character) Regional Manager, District Manager and Locations. When I click on any of those 3 I get the error: "An invalid column was specified in your request (the column does not exist on the dataset)".
It is my understanding that as long as both datasets share the column I'm clicking on then the drill down should work. Please help