We want revenue and net income information on our dashboard, but they live in two different pivot tables in our data. Additionally, there is more information in those pivot tables than we want on our dashboard. The answer to this is—Microsoft's
GetPivotData formula. Fortunately, you don't really need to spend much time figuring how to use the formula. Let's set up revenue and net income on our dashboard. To do this, follow these steps:
As a reminder, our revenue pivot table looks like this:
Now that we have ...