this is my second video on powerpivot now I found this this data on the
Internet as sample data so I assume it's fictitious but I have 9,000 rolls of
data here I created a table and I've linked it to my power pivot by clicking
on this to add to a model and now it's put into my my powerpivot function what
I will show you is when it's in here it looks very much like what it did before
so what we're going to do is previously we created a pivot table but let's
create something else here below the pivot table we have a drop-down list and
so let's create a dashboard of sorts and so what we're gonna do is we're gonna
create 4/4 charts on one page and it's asking yes this is back on our excel
sheet and yes I'd like it on a new sheet we have our worksheet with 4 charts on
it so to see the field types we need to have a field list we can put things on
here so what we're gonna do is we're gonna go to the analyze part of the
pivot tools chart here and we're gonna go field list now it will show us our
table and all the fields that we have in here ok so I am going to drag and drop
into the different parts of the pivot table chart here and so what I'm going
to first do is I'm going to take States so I'm going to put state as access
access and then I am going to put I'm going to total the sales for each state
so that's going to be my first chart and so there you have the the chart or the
states and their sales for each one of them so in the next chart I would like
the categories of the products that they sold let's break down so we get
categories
and we're gonna put that one there and then I'm going to put subcategory as
well underneath that and then I'm going to total up the amount of sales that
they had for each category and subcategory so I'm gonna drag sales into
the some value here what they sold the category is furniture office supplies
technology and there's the totals of all this will go down to our third chart and
I think on my third chart I'm gonna click on this and I'm going to change
chart type and I'm gonna change it to a PI and I think that one looks nice and
so I'll say okay and now I'm going to select for this pie chart I would like
the categories and the total sales by each so I'm going to select my values
and I would like categories and then I'll have total sales of each so there
we have a nice nice pie chart done for us
so we have furniture office supplies and Technology so for my fourth chart I am
going to go sales as as a barback sales of the bottom axis and quantity as the
total value here so there you go so now this is looking pretty good but let's
put a slicer on here just to change things up so let's go up to the top here
and what we're going to do is I'm going to make a little space here so I'm gonna
push these things over a little bit and then I'm gonna go to my on my analyze
chart I'm going to go insert slicer and I have a slicer by the state so I'm
gonna see what part of the state is more of each product so my I'm gonna
select state from here and say ok so here we have our states in between there
so now let's drag this across you can see and so now we rate rate at this
moment we have everything in there so let's let's see what California had
bought and so that's what they bought they bought more office supplies it
seems or different amounts of them and let's see what Delaware bought and it
all changes so with from the slicer and Florida see what they bought in Illinois
so from the slicer you get to see different views of your pivot table that
you have your pivot charts that you have created on your power pivot this is one
more aspect of the power pivot please subscribe