To illustrate this I'm going to type the = sign,
click into our pivot table and you can see that a formula was auto populated.
So it says GETPIVOTDATA, Revenue, F44,
which is the first cell of our pivot table, Country, and France.
So, very easily here, we just typed the = sign and clicked in and
this formula will pull the revenue for the country of France within our pivot table.
Other ways to access this function other than to hit = and
click into your pivot table,
you can also type out the function by typing = and typing GETPIVOTDATA.
Or if you have a function that's already referencing your pivot table data, you can
just copy that down and change some of those fields to get the desired data.
In 5C it's your turn to filter for
countries with revenue between $2000 and $3000.
Since we're looking at dollars, you're going to use a value filter.
Read through the options in the value filter's menu to try to get to this answer
as efficiently as possible.
Problem 5D asks us to complete the following chart based on the pivot table
you used in Problem 5C, by editing the pivot table reference formula.
Let's click into the table to see what we're starting with.
So, it looks like someone typed in Canada in this cell.
And in the next cell there is a formula, it says GETPIVOTDATA(Revenue,
a cell reference, Country, Canada.
If we click into this formula up above we'll get a little more information.
Now, the formula says, GETPIVOTDATA( and then asks for
the data field you are trying to get.
And we are trying to look at Revenue.
Next, it says the pivot table, so
we reference the cell where the pivot table starts.