joined data

As the title suggests, this nifty trick has the dual purpose of allowing you to trigger sheet swaps using Dashboard Actions and, when two data sources contain different levels of Granularity, it lets you analyse at both levels (the Granularity of the Primary and Secondary data source). This is the ‘illusion of a Full Outer Join’…All seems a little cryptic and techie. Let’s run through an example…