All right.
So let's talk about a very important feature of power.
That is drilled through between the gaps through between the tabs in simple language it will help us
to filter out same values in multiple tabs.
So if there are same values in page 1 and we want to see the filter in page two as well for the same
value we can use them.
So for example when I click here on Australia and this table I can see that all these well you have
been trained on the beaches of Australia but if you want to see these changes in page two as well.
This is not possible directly so power is provided very good feature here called to between the DAPs.
So let me show you how it works.
So when you or if you want.
So suppose I have in this country filled here.
So let's work on country only.
So I just simply drive this country in the region.
Once it is here I can use that to filter important part here.
Notice you cannot really work only by adding to filtering only one page.
If you want to do it through from page to page to keep an order you'll have to add the same field in
which to as well.
All right so now both of our pages are having the same data to down.
So now if I select any of these countries up all I want to see for Australia I will right click on it.
And when I read it like I would see this drilled through filter.
And when I click on page 2 bam there we go.
It has been already been filtered for Australia as you can see this wonderful data showing showing Vellis
only for Australia.
Here it is for Australia.
So it has been filtered only for Australia.
If you go down here you can see that trail to filter have already been challenged on that Australian
so I'll clear the filter and I can select it for any other country.
Suppose we can to Spain here and we will see the valleys of Spain that exist.
So that's how truthful that was.
We can add as many readers as we want to both of your chosen countries here we can filter two product
lines and so many more so now I have to add this product in which you do as well.
There we go.
So now if I click one Suppose I want to know about motorcycle's right click on it.
I want to drill through on page 2.
Now I will see all the sales value of motorcycle in page to the this is how it works.
As you can see it is being filtered gantries USA for the motorcycles because that's what we have selected.
We are still after country here.
U.S. and black motorcycles or whatever Vivus Jews drilling in page one.
We can apply it to page two as well.
This is Rick this comes really very handy when you have Suppose seven or eight tabs up here and you
want to see changes from your page one filter to it filters so you can simply do this.
This is how that works.
I hope that helps and we'll continue in the next lecture.